Hi All,
I have data scenario where in my input data is coming with apostrophe( Highlighted in red) like below
SELECT * FROM TABLE
where ERR_DESC='O'NEIL';
I have starting and ending quote because the column is varchar column.
It is giving out error. i tried using REPLACE but not able to handle the above scenario. Please let me know how this can be handled.
Thanks.