Re: SQL Script question (DISREGARD)

2005-01-26 Thread ColdFusion Developer
Answered my own Stupid question.. too early in the morning! ColdFusion Developer wrote: >I am compiling a MS SQL Script to insert records into a database. >However some of the fields have the single quotes such as: Member's Name > >This chokes the SQL Query Analyzer since the single quotes are

SQL Script question

2005-01-26 Thread ColdFusion Developer
I am compiling a MS SQL Script to insert records into a database. However some of the fields have the single quotes such as: Member's Name This chokes the SQL Query Analyzer since the single quotes are used as field qualifiers. Anyone know how I can still get the single quotes into the DB withi