Supplementary Characters (Surrogate Pairs) The expression must be varchar(max) or varbinary(max) when the start or length contains a value larger than 2147483647. The values for start and length must be specified in number of characters for ntext, char, or varchar data types and bytes for text, image, binary, or varbinary data types. The returned string is the same type as the specified expression with the exceptions shown in the table. Returns binary data if expression is one of the supported binary data types.
Returns character data if expression is one of the supported character data types. If the sum of start and length is greater than the number of characters in expression, the whole value expression beginning at start is returned. If length is negative, an error is generated and the statement is terminated. Is a positive integer or bigint expression that specifies how many characters of the expression will be returned. If start is greater than the number of characters in the value expression, a zero-length expression is returned. In this case, the number of characters that are returned is the largest value of either the sum of start + length- 1 or 0. If start is less than 1, the returned expression will begin at the first character that is specified in expression. (The numbering is 1 based, meaning that the first character in the expression is 1). Is an integer or bigint expression that specifies where the returned characters start. Is a character, binary, text, ntext, or image expression.
To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation.
0 kommentar(er)
