single quotes in a query

[gm456]

How can I get an SQL query to work on a name that includes a quote mark -

eg: form.name contains o'donnell

SELECT *
FROM people
WHERE name like '%#preservesinglequotes(form.name)#%'

No matter what combination of single or double quotes I try, it ain't working, with or without preservesingle quotes

TIA guys! [sig][/sig]

 

[perichazhi]

Try this,

SELECT *
FROM people
WHERE name like '%#Replacelist(#form.name#,"'","''&quot#%'


This should work,

Perichazhi


[sig][/sig]