Conversion of Sybase Adaptive Server Anyware TRIM to Microsoft SQL Server

Please, note, that Ispirer SQLWays 6.0 is no longer supported and provided to clients.

You can try out automated conversion of databases and applications with Ispirer Toolkit for free. Download free trial.

Check out the relevant toolkit documentation.

Ispirer Sybase ASA to SQL Server Migration overview.

Ispirer SQLWays Database Migration Software
Conversion of Sybase Adaptive Server Anyware TRIM to Microsoft SQL Server

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 65. 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