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