Was hoping to avoid this as it is accounting info and breaking scripts may introduce errors. Also must be replicated possibly three times prior to final conversion.

Found that I...

the data is from a dbase5 file and formatted by an export tool. It seems by cursory view of bcp or bulk import that the formatting included in my...

If I response.write the sql string generated by the code and copy and paste into query analyzer, the query runs without fail.  The problem is not the single quotes and I...