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