In the client/server mode, the SUBSTRING () function is implemented using the SUBSTRING() function of the respective SQL operator passed to the database server (SQL Server). The result of the SUBSTRING () function is a string of variable length and its length is considered unlimited if has unlimited length and the parameter is not a constant or is greater than 1024.Ĭalculation of the SUBSTRING() function on an SQL Server ![]() It is applied to string data. It selects a part of the that begins with the character at position (the first character is considered to have number 1) and has a length of characters. ![]() In the 1C:Enterprise query language the SUBSTRING () function has the following format: SUBSTRING(,, ). This section covers the specifics of executing the SUBSTRING() function of the query language in the client/server mode and the tips for building queries with this function.
0 Comments
Leave a Reply. |