I have a table where I need to insert a '*' sign before a lot of names. My table looks like this now:
id,name 1,cake 2,car 3,mountain
And it should be:
id,name 1,*cake 2,car 3,*mountain
The name column is nvarchar. I have the ids in a csv file. I thought I could make the update statement with concat and a where clause with the IDs, but I can't get it to work.
UPDATE table SET NAME = concat('*', NAME) WHERE id = '1' OR id = '2'
Msg 195, Level 15, State 10, Line 11 'concat' is not a recognized built-in function name