RE: Ampersands in data - this might be useful?

6 less, if you count the shift key

(and I do count the shift key!)

:)

-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Norman Dunbar
Sent: Monday, June 25, 2012 10:47 AM
To: [email protected]
Subject: Re: [toad] 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]



<BR>_____________________________________________________________
<FONT size=2><BR>
DTCC DISCLAIMER: This email and any files transmitted with it are
confidential and intended solely for the use of the individual or
entity to whom they are addressed. If you have received this email
in error, please notify us immediately and delete the email and any
attachments from your system. The recipient should check this email
and any attachments for the presence of viruses.  The company
accepts no liability for any damage caused by any virus transmitted
by this email.</FONT>


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

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/