Hello.
I 'm working on a project which has developed a huge program. Some
customers use DB2 as database, and others oracle.
So far so good and everything works ok.
Now there's a demand on using SQL server. We have found two major
problems.
1) Trim()
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)
2)Concatenation
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?
As you can imagine sql statements are used all over the application and
we are talking about hundred of sql statements. I 'm sure other people
have had the same problem. Is there a workaround?
Thanks
