In ASE, the Like operator automatically performs an RTrim on its right hand argument. On MS SQL Server, the right hand argument is treated ‘as is’. This might lead to differences in behavior if the right hand argument contains trailing spaces.

Example

if 'abcde' like '%cde '

print 'they are alike'

else

print 'I spot a difference'