2.1.1.6 E021-06, SUBSTRING function

  • Article

V0006:

The specification states the following:

 Subclause 6.30, "<string value function>":
  
 <character substring function> ::=
 SUBSTRING <left paren> <character value expression> FROM <start position>
 [ FOR <string length> ] [ USING <char length units> ] <right paren>

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

Transact-SQL does not support this feature. See the Transact-SQL SUBSTRING function [MSDN-SUBSTRING], which differs significantly in syntax and features, for equivalent functionality.