Queriying a field with an apostrophe

[Guest_imported]

I have a field, playmates_last_name.
One of the records has a name "O'NEAL".
How can I write a sql statement to get the record with "O'NEAL" as a last name? [sig][/sig]

 

[THoey]

The following will help, but I know there has to be a better way...

SELECT * 
FROM your_table_name_here
WHERE playmates_last_name like '%NEAL'

Hope that helps until someone wiser than me comes along...
[sig]<p>Terry M. Hoey<br><a href=mailto:th3856@txmail.sbc.com>th3856@txmail.sbc.com</a><br><a href= > </a><br>Ever notice that by the time that you realize that you ran a truncate script on the wrong instance, it is too late to stop it?[/sig]

 

[Advocate]

Try this ... select playmates_last_name from table where playmates_last_name like 'O''NEAL'
[sig]<p>Best of Irish Luck, David.<br><a href=mailto:djwilkes@hotmail.com>djwilkes@hotmail.com</a><br>[/sig]