Click to See Complete Forum and Search --> : help on insert pls


visio
10-25-2000, 10:10 AM
Quick question. I forgot how to insert a string into a table with a & symbol within it. ex: xxxxx&yyyyy.
thanks

ssu4716
10-25-2000, 12:21 PM
The ASCII value for '&' is 38. So you can insert the string as 'xxxxx'||chr(38)||'yyyyy'

Thanks.

-Syed