The Sybase Adaptive Server Anyware TRIM function removes leading and trailing blanks from the specified string. Microsoft SQL Server does not support the TRIM function, but RTRIM and LTRIM functions can be used to remove both leading and trailing blank characters.

SQLWays converts Sybase Adaptive Server Anyware TRIM to Microsoft SQL Server RTRIM with LTRIM, as shown in the example below.

TABLE 54. Example of the Conversion of Sybase Adaptive Server Anyware TRIM to Microsoft SQL Server

Sybase Adaptive Server Anyware	Microsoft SQL Server
create procedure asa_sp_trim ( ) begin select trim (' hello '); end;	create procedure asa_sp_trim AS begin select rtrim(ltrim(' hello ')) end