Re: Concatenate in MSSQL

>> There's no trim in MSSQL. Even if we create a trim() function to user
ltrim(), rtrim() as far as I have searched one must call dbo.trim(field)
instead of trim(field) <<

Use a text editor to change trim() to ltrim(rtrim()), getdate() to
CURRENT_TIMESTAMP, etc.  This is some of the "****table, but not
Standard" syntax in SQL Server.  That means you can fix it with a dumb
text editor.

>> Oracle and DB2 works with the ANSI operator ||. Apparently SQL server
doesn't :-( Is there a way to force the MSSQL to be ANSI compatible?  <<

They overload the + for concatenation.  That can be a ***** and you
wind up doing it by hand -- did you want "<numeric> + <string>" to
cast to numeric and add or cast to strings and concatenate?