If values are stored in varchar fields, ASE automatically performs an RTrim on the data, whereas MS SQL Server treats the data ‘as is’. This can lead to different behavior in the client, or different content when a variable or field receives a value by concatenating some other fields.

Example

create table T (v varchar(10), c char(10))

insert into T values ('snow ', 'rain')

select '*' + v + '*', '*' + c + '*' from T

drop table T