Re: Ampersands in data - this might be useful?

Hi Martin,

On 24/06/12 00:54, Martin Gainty wrote:
> Thanks for the update!
> i ran into this same situation when attempting to construct values
> clause for my INSERT Statements...the solution which worked for me used
> the CHR(dec) e.g.
> INSERT INTO FLOYD_SONGS VALUES('Us '||CHR(38)||' Them');
>
> select * from FLOYD_SONGS
> 'Us & Them'

Yes, that also works and is quite well known. However, I prefer to see 
the data, wherever possible, I'm inserting - so I'd be slightly loathe 
to use "chr(38)" if I could use the '&' instead. Plus, being a lazy sort 
of person, '&' is 4 characters less to type! ;-)


-- 
Cheers,
Norm. [TeamT]




------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/