Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 search for string with apostrophe

Author  Topic 

bciarcia
Starting Member

28 Posts

Posted - 2002-08-19 : 16:49:02
I am doing a search on an Access database that searches for a clients last name. Everything works fine until I get to a name like O'Brien. How do I do a search for this? I tried replacing the ' with '', but that doesn't work. Could someone please help me? I will also post this in the MS Access forum just in case.. Thanks in advance.

LarsG
Constraint Violating Yak Guru

284 Posts

Posted - 2002-08-19 : 18:29:30
Don't crosspost. It's sufficient to post in the Access forum where it already has been answered.


Edited by - LarsG on 08/19/2002 18:33:50
Go to Top of Page
   

- Advertisement -