replacing single quotes with double quotes 2

[lel75]

Hello,

I have problems querying through a web application system when a name has a single quote in it (e.g. O'Brien). Can you please show me how I can change this select so that the single quotes get replaced with double quotes? I've tried the REPLACE and the ESCAPE function but it does not work.

select_statement := select_statement || where_clause_append ||'last_name = ''' || UPPER(te_last_name) || '''';

Thanks in advance!

Cathy

 

[dbtoo2001]

This was covered recently in thread:
thread186-703654

 

[SantaMufasa]

Cathy,

My apologies for not understanding your "select_statement" clause, but you can certainly use some variation of this code:

...replace(UPPER(te_last_name),chr(39),chr(39)||chr(39))...

This tells Oracle that wherever it encounters a single quote [chr(39)] within te_last_name, replace it with two single quotes.

Dave
Sandy, Utah, USA @ 19:24 GMT, 12:24 Mountain Time

 

[lel75]

Dave,

That worked! Thanks again for all your help.

Cathy