select concat('a','b');
gives the error
Msg 195, Level 15, State 10, Line 1
'concat' is not a recognized built-in function name.
This is despite CONCAT appearing in the intellisense dialog when typing.
EOMONTH and FORMAT also cause the same problem. There are probably others. Am I missing a plugin or a library or something?
Go to the complete details ...