Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
V0209:
The specification states the following:
-
Subclause 6.30, "<string value function>": <binary value function> ::= <binary substring function> | <binary trim function> | <binary overlay function> ... Conformance Rules Without Feature T042, "Extended LOB data type support", or Feature T022, "Advanced support for BINARY and VARBINARY data types", conforming SQL language shall not contain a <binary value function>. Subclause 8.5, "<like predicate>": <octet like predicate> ::= <row value predicand> <octet like predicate part 2> <octet like predicate part 2> ::= [ NOT ] LIKE <octet pattern> [ ESCAPE <escape octet> ] <octet pattern> ::= <binary value expression> <escape octet> ::= <binary value expression> ... Conformance Rules Without Feature T042, "Extended LOB data type support", or Feature T022, "Advanced support for BINARY and VARBINARY data types", conforming SQL language shall not contain an <octet like predicate>.
Microsoft SQL Server 2008 R2 and Microsoft SQL Server 2012 vary as follows:
Transact-SQL does not support this feature.