2.1.1.8 E021-09, TRIM function
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.