Searching for Apostrophes
Written by Eric Smith, Northstar Computer Systems LLC
This question comes up a lot: how to search for a name like O'Brien from within SQL. The problem is that the single quote character is used to delimit strings within SQL. The solution is to search for two single quotes. If you put this in your query, your database will translate those two single quotes into a single quote that it needs to find. This is a common problem in SQL Server, Oracle, and many other databases.
Keywords: [
SQL
]
Publication Date: 9/1/2000
|