Getting error when using concat function

Question

Why I cannot use concat function? When I run my script, this error will appear.

Msg 195, Level 15, State 10, Line 2. 'concat' is not a recognized built-in function name.

update dbo.[1A]
set Organization_ID = concat (Organization_ID, '-meow');

Which Version of SQL SERVER you are using? What is the datatype of Organization_ID column ? — Pரதீப்
– Pரதீப், Commented Sep 19, 2016 at 8:08
SQL SERVER 2008. Datatype of Organization_ID is nvarchar(255) — ika
– ika, Commented Sep 19, 2016 at 8:30
Try this update dbo.[1A] set Organization_ID = Organization_ID + '-meow '; — Pரதீப்
– Pரதீப், Commented Sep 19, 2016 at 8:39

Mark · Accepted Answer · 2016-09-19 08:07:37Z

1

concat is available from SQLServer 2012,you can use + to get the same result

also use Isnull to avoid nulls Isnull(Organization_ID)+ '-meow'

Mark

2,0433 gold badges22 silver badges43 bronze badges

answered Sep 19, 2016 at 7:59

TheGameiswar

29k9 gold badges66 silver badges106 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1