Adding to existing info in a field 1

[sinbadly]

In Command Prompt, I want to add a number to 'address' for, say, id = 23.

Is there a way to say append or concatinate the record with this additional information? In other words, NOT to do what update seems to do, and that's remove everything else. Cheers, experts.

 

[r937]

update daTable
set address = concat(address,'booya')
where id = 23

r937.com | rudy.ca

 

[sinbadly]

Thanks, Rudy. You gave me this back on 9/2/05, but I couldn't find it in my sql notebook, and then found it at the weekend.

Very much obliged to you.

 

[sinbadly]

Hi Rudy

Help, Guv', why won't this work, please?

update parletter
set blurb = replace('September: ', blurb)
where blurb like '%September%';

Could it be that when I inserted the word September, I forgot to put a space after it, so that now each sentence in 'blurb' has September well and truly concatinated on the first word?

Cheers

 

[r937]

you should look up the syntax for REPLACE

you've got the parameters wrong



r937.com | rudy.ca

 

[sinbadly]

Cheers, r973.