Thanks, works well.  This is a pretty neat utility to find items across all tables of a large database. 

Is there any other command that would work in place of CAST?

To claify, it will work for numeric type, not money.

I did send the developer of the stored procedure an email.  If he sends me anything, I'll post it here.

Actually it will work, if the following line is modified:

DATA_TYPE IN ('char', 'varchar', 'nchar', 'nvarchar','numeric')

So by adding ,'numeric' I can search numeric field types also.  I need to search money...

Thank you, worked well

Thanks all

Here is a solution to my problem.  Basically I find the location of the first and second quotes, delete all commas between the two, then delete the first set of...

I was thinking, using CHARINDEX I could locate the first instance of the double quote.  Then use CHARINDEX again to find the second instance

0000000001111111111222222222233333333334

1234567890123456789012345678901234567890

xx,"1,000",xxxxxxx,"2,000",xxxxxxxxxxxxx

So...

I'm a hackboy.  I can get some stuff done in SQL Server, but I'd probably have an easier time learning to speak German than understand DTS, LOL.

Actually, I could use...

rockmouse thanks for the link for bcp out  ...  I need that for another task, this mkeast solution for this parsing issue is slick

mkeast  ...  WOW  .... this is really cool, thanks again

mkeast, thanks for your patience and help

I'm still having a problem.  Lets assume I have a table called SlowThinker (that me, LOL) and it contains one field, ExData.  There are numerous records in...

rockmouse, I know how to bulk insert in, how do I bulk insert out?

If I have a table with a single field, say TestData..Field01, how do I create a file...

mkeast, interesting solution, the type of thing I was hoping for

excuse my stupidity, but when I try to replace the @s-2 with the field that contains this string...

That worked like a charm. I had to add a GROUP BY acct_no in part 2

Thanks again