Depends.

There is three kind of DVI cable afaik.

DVI-I, DVI-D & DVI-A.

D for digitial
A for analog (DVI->VGA adapters...)
I for integrated (both A & D).

Most recent computer LCD screen have only DVI-D.

I am no expert on the subject but you can certainly catch some more advice with wikipedia on the subject.

Here is the revelant wikipedia link on this subject : http://en.wikipedia.org/wiki/Digital_Visual_Interface

Also, it is possible to link DVI to/from HDMI -> hook your HDMI LCD TV to your DVI computer video output.

I did once for my Efika. It works really nice :)