The Best thing u can do concatenate date and time differently in the 
some function  and then make the coloumn variant or text feild or may be 
write a trigger or a function whenever user updates it or inserts the 
data in the coloumn it is changed by the function then u can accomadate 
the date a time in the column

hope this helps
thx
sid



-----Original Message-----
From: SD-Studios [mailto:info@s...]
Sent: Tuesday, July 09, 2002 2:53 PM
To: ASP Databases
Subject: [asp_databases] SV: Returning only date fields with a value


Hi!
I am currently running MS SQL Server 2000. Is there a way to make the
datetime-field longer, so that it can contain both date and time..? 
Thanks!
--
MVH, Martin Johansson
CEO & Project Supervisor
SD-Studios, Squaremedia HB
+46 (0)70-3003320
http://www.sd-studios.com
http://www.swehost.com

Hi!
I am currently running MS SQL Server 2000. Is there a way to make the
datetime-field longer, so that it can contain both date and time..? Thanks!
--
MVH, Martin Johansson
CEO & Project Supervisor
SD-Studios, Squaremedia HB
+46 (0)70-3003320
http://www.sd-studios.com
http://www.swehost.com