Share via

2.1.1.8 E021-09, TRIM function

  • Article

V0008:

The specification states the following:

 Subclause 6.30, "<string value function>":
  
 <trim function> ::=
 TRIM <left paren> <trim operands> <right paren>

Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:

Transact-SQL does not support this feature. See the LTRIM [MSDN-LTRIM] and RTRIM [MSDN-RTRIM] functions for equivalent functionality.