O'BRIAN fix for SQL

[James Stanich]

I know that this has had to come up before. Is there a safe way of determining that a string (like a last name) includes a " ' "? This, I know, will become a problem when logging in employees to my Access 2000 table.

Any suggestions?

[d.paulson]

Here is a snippit from one of my programs to solve this.

strCustomerName = Replace(rsCustomers!CustName, "'", "''")
rsCustomers.Find "CustName = '" & strCustomerName & "'"

[James Stanich]

I know it has been awhile, but I finally got to use the code yu supplied and it works great !!! Thanks once again.