In ASE you can use both the + operator and the || operator to concatenate strings. In MS SQL Server, only the + operator exists.