Tag:substring asc -- intercept upper ring length sql highlight
The/*len (string) function lower (string) function upper (string) function LTrim (string) function RTrim (string) function substring (string,start_position, Length) function charindex (string,substring) function left (string,length) function right (string,length) function ASCII (string) function ASCII (string) function */select left (' ABCDEFA13BSCDESFSDFDSFG ', 5) ' left ' Select Right (' A13BSCDESFSDFDSFGEDCBA ', 5) ' right ' select LEN (' Abcdefghigklmnopqrstuvwxyz ' LEN ' select UPPER (' abcdefghijklmnopqrstuvwxyz ') ' UPPER ' Select LOWER (' ABCDEFGHIJKLMNOPQRSTUVWXYZ ' LOWER ' select SUBSTRING (' abcdefgh start position is 7 intercept length 13IJKLMNOPQRSTUVWXYZ ', 9,13) ' SUBSTRING ' Select ASCII (' a ') ' Ascii:a ', ASCII (' z ') ' Ascii:z ', ASCII (' a ') ' Ascii:a ', ASCII (' z ') ' ascii:z ' Select RTRIM (' _ _ABCDEFG--- --0 ') ' Go to the right space ', LTRIM (' 0_ _ABCDEFG-----0 ') ' Go left space ' select Ieft (' Abcdefa13bscdesfsdfds FG ', 5) ' left ', right (' A13BSCDESFSDFDSFGEDCBA ', 5) ' Right ', Len (' abcdefghigklmnopqrstuvwxyz ') ' Len ', UPPER (' ABCDEFGHIJKLMNOPQRSTUVWXYZ ' UPPER ', LOWER (' abcdefghijklmnopqrstuvwxyz ') ' LOWER ', SUBSTRING (' abcdefgh ' Start position is 7 sectionTake length 13IJKLMNOPQRSTUVWXYZ ', 9,13) ' SUBSTRING ', ASCII (' a ') ' Ascii:a ', ASCII (' Z ') ' Ascii:z ', ASCII (' a ') ' Ascii:a ', ASCII (' Z ') ' Ascii:z ', RTRIM (' _ _ABCDEFG-----0 ') ' Go right space RTRIM ', LTRIM (' 0_ _ABCDEFG-----0 ' Lrtrim Go left space '
SQL string Functions