Quick question. I forgot how to insert a string into a table with a & symbol within it. ex: xxxxx&yyyyy.
thanks
Printable View
Quick question. I forgot how to insert a string into a table with a & symbol within it. ex: xxxxx&yyyyy.
thanks
The ASCII value for '&' is 38. So you can insert the string as 'xxxxx'||chr(38)||'yyyyy'
Thanks.
-Syed