Merely as another column.

Ah ok well I was talking about when making the type value I only could see stuff like SmallDateTime.

Ya I figured it out. I was missing a comma that's all.

Glad it works now, cheers! Anything left unsolved for this thread?

You add it to the select like it was another column.

Something like "SELECT A,B,C,DATEDIFF(d,onedate,thecolumnyouneed) FROM ..."

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========