Concatenate text

[blocktl]

can anyone tell me what's wrong with this syntax?

UPDATE tablename

SET tablename.vendorid = left(tablename.vendorid,3) + ‘V’ + right(tablename.vendorid,3);

 

[SQLSister]

YOu seem to have used accent marks instead of single quotes. At least that is what showed up when I ran this in QA. Also, you don;t need to use the; at the end of a SQl Server query. It will still run, but why waste time typing unnneded characters?

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief

 

[bassguy]

hi,

couple of things I see to try:
1. your single quotes look like curly quotes. i do not know if that is the html page or your real text, but that could be a problem.

2. if your column is Text or nText you cannot Concat it

HTH

Tal

 

[bassguy]

SQL sister was too fast. lol