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

Removing (or Trimming) Characters from a String

This section describes functions which remove (trim) characters from the specified string in various databases and their conversion by SQLWays.

TABLE 64. Removing (or Trimming) Characters from a String

Database	Syntax	Description
Sybase Adaptive Server Anyware	TRIM (exp)	TRIM removes leading and trailing blanks from exp string.
	RTRIM (exp)	RTRIM removes trailing blanks from exp string.
	LTRIM (exp)	LTRIM removes leading blanks from exp string.
Microsoft SQL Server	RTRIM (exp)	RTRIM removes trailing blanks from exp string.   Return type: VARCHAR   exp is an expression of character or binary data. exp can be a constant, variable, or column. exp must be of a data type that can be implicitly converted to VARCHAR.
	LTRIM (exp)	LTRIM removes leading blanks from exp string.   Return type: VARCHAR   exp is an expression of character or binary data. exp can be a constant, variable, or column. exp must be of a data type that can be implicitly converted to VARCHAR.