search string having apostrophe
247890Jan 31 2007 — edited Feb 2 2007Hi -
tables are storing string with apostrophe in them. There is a search facility on the web front end side, which essentially searches db table. when the user searches string with apostrophe, how to construct the query?
parameter P1 - is simply capturing the string being passed as is (Jan's)
when I search in the table where statement is as follows:
select * from t1 where col1 like P1;
Please suggest. Thanks
Message was edited by:
user6773