Resolving apostrophe in SQL

[edsperez]

How do you write a sql using a like function and the column uses apostrophe.

Ex.

select clnt_name from my_clnt where upper(clnt_name) like upper('St. Vincent's');

[Shestakov]

select clnt_name from my_clnt where upper(clnt_name) like upper('St. Vincent''s');

[edsperez]

The query did worked, Do you have any other way of doing that. Let's say I'm an ordinary user and I am querying the database. You don't expect me to put two(2) single quote on the apostrophe...right.

Thanks,

Ed

[jmodic]

Originally posted by edsperez
Let's say I'm an ordinary user and I am querying the database. You don't expect me to put two(2) single quote on the apostrophe...right.

If you are an ordinar user and you are querying the database *by typing the queries yourself* (using SQL*Plus or similar tool), *you are expected* to put two single quote on the apostrophe - that's how it works.

If you are an ordinar user and you are querying the database *by using a canned application*, then your programers are expected to take care of this to make life of application users easier....