hi, thanks for the help...

MS-sql server and tab delimited text files.

I do a bulk insert and it works if I have column 5 to varchar in the table or format file. But column 5 is a date in format

24-Feb-2004 12:00:00 PM EST

Which is all great other then the EST at the end kills me. If datatype is smalldatetime then it says bad conversion during bulk insert. But if I edit text file manually and delete EST then it all works fine. I need field to stay date for querying later. Is there a way to trim from the left (LEFT in VBScript) during a bulk insert? Or is there a way or datatype to use?

thanks in advance..

Nick

You could use the REPLACE SQL function. This seems to work...

REPLACE('24-Feb-2004 12:00:00 PM EST', 'EST', '')

Peter
------------------------------------------------------
Work smarter, not harder.