Don't forget listQualify() when you're doing this sort of stuff. Cheers, Robin
______________ Robin Hilliard Director - RocketBoots Pty Ltd Consulting . Recruitment . Software Licensing . Training http://www.rocketboots.com.au For schedule/availability call Pamela Higgins: w +61 7 5451 0362 m +61 419 677 151 f +61 3 9923 6261 e [EMAIL PROTECTED] or Direct: m +61 418 414 341 e [EMAIL PROTECTED] On 10/04/2007, at 1:35 PM, KNOTT, Brian wrote: > Thanks Steve, I knew it was something simple. > > Brian > > From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] > On Behalf Of Steve Onnis > Sent: Tuesday, 10 April 2007 1:32 PM > To: cfaussie@googlegroups.com > Subject: [cfaussie] Re: '' in SQL statement > > PreserveSingleQuotes(string) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---