Table of ContentsPreviousNext

Ispirer             Ispirer


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


Table of ContentsPreviousNext
Ispirer             Ispirer
Copyright © 1999-2015 Ispirer Systems Ltd. Ispirer and SQLWays are trademarks of Ispirer Systems Ltd. All other product names may be trademarks of the respective companies. All rights reserved.