sql函数（SQL function）.docVIP

sql函数（SQL function） Character conversion function 1, ASCII () Returns the ASCII code value of the leftmost character of the character expression. In the ASCII () function, a string of pure numbers is not enclosed, but strings containing other characters must be used with , or they will go wrong. 2, CHAR () Converts ASCII code to characters. If no ASCII code value between 0 and 255 is entered, CHAR () returns NULL. 3, LOWER () and UPPER () LOWER () converts all strings to lowercase; UPPER () converts all strings into uppercase. 4, STR () Converts numeric data into character data. STR (float_expression[, length[, decimal]]) Length specifies the length of the string to return, and decimal specifies the number of digits to return. If no length is specified, the default length value is 10, and the decimal defaults to 0. When length or decimal is negative, return NULL; When length is less than the number of digits to the left of the decimal point (including symbol bits), returns length *; Submit to length, then decimal; When the number of strings returned is less than length, the left side makes up the space. Two, to the space function 1, LTRIM () the string header space removed. 2, RTRIM () remove the space at the end of the string. Three, take the child string function 1, left () LEFT (character_expression, integer_expression) Return character_expression, left, integer_expression characters. 2, RIGHT () RIGHT (character_expression, integer_expression) Returns character_expression, integer_expression characters on the right. 3, SUBSTRING () SUBSTRING (expression, starting_, position, length) Returns the part of length characters from the starting_ position character on the left of the string. Four string comparison function 1, CHARINDEX () Returns the starting position of a specified substring appearing in the string. CHARINDEX ( substring_expression expression) Where substring _expression is the character expression to look for, expression can be a string, or column n