Search for names containing the ' char

[Boorgy]

Hi there SQL experts...

There's this problem I've been stuck on for a few hours:
I have a search query that checks for the name, like:
SELECT IDnumber FROM Employees WHERE Name='-----'

The problem is some of the names contain the ' char (O'Connor... who put an irish name in a database?)
Of course, Name='O'Connor' doesn't work...
Anybody got a bright idea?

Thanks

Nick

 

[JoeMiller]

Use double quotes instead of single quotes around your string:

SELECT IDnumber FROM Employees WHERE Name="-----"

Then you don't have to worry about ' Joe Miller
joe.miller@flotech.net

 

[MichaelRed]

use double quotes? {Chr(34) vs Chr(39)}?
MichaelRed
mred@att.net

There is never time to do it right but there is always time to do it over