No, you still have so much stuff to learn... like using a function to do this task .

There's no such thing as too fast .

Don't...

Why do you think you need to do this?

Just use Jo's version combined with my split function. That's all there is to it. It's pretty straight forward from there.

You seem to be right. You'll have to look up the exact syntax in bol and fire it that way. But it shouldn't be too hard.

NP, HTH.

Actually, it can easily be done with a straight select... but we still need to know what data you need returned to the client.

It can be done but why do you want to do that??

Please do not cross-post as we monitor all the boards.

I already answered that question here : http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=219329

Please bare with me as this script is quite long. But the sp at the end is extremely versatile and this is what you need in this case :...

Is this a CSV file or something like that???

You could then use dts to import the data to a table.

Swith this around. Insert into a table, then search on it using like or full text search.

This is what I have, but my results don't match up with yours (some maths error I guess).

Can you verify that this is what you need??

Declare @BT table (TDate smalldatetime...

I second that request .

As I said it IS possible with the bulk insert, check the books online for the exact syntax.