Hi All,
How to fetch a record from a column having a value like Jack's david.when i try to fetch this value within single quotes like 'jack's david' it throws unclosed quotation mark.How to use escape sequence for singles quotes
Thanks,
R.karthik
You can escape single quotes by adding a single quote. (I know it sounds weird).
SELECT * FROM TABLE WHERE VALUE LIKE 'Jack''s David'
Will result in Jack's David
Joey Moree wrote:
Hi Joey,
Thanks for the Solution