sql
Khóa học miễn phí SQL – String Functions nhận dự án làm có lương
SQL – String Functions
SQL string functions are used primarily for string manipulation. The following table details the important string functions −
| Sr.No. | Function & Description |
|---|---|
| 1 |
Returns numeric value of left-most character |
| 2 |
Returns the character for each integer passed |
| 3 |
Returns the position of a substring within the given string. |
| 4 |
Returns concatenate with separator |
| 5 |
Returns concatenated string |
| 6 |
returns an integer value measuring the difference between the SOUNDEX() values of two different expressions(strings). |
| 7 |
Returns a text with escaped characters. |
| 8 |
Returns the formatted string. |
| 9 |
Returns the extracting string. |
| 10 |
Returns the length of the given string. |
| 11 |
Returns returns the lower case of the given string. |
| 12 |
Returns a string after removing all the white spaces and characters from the string found on the left side. |
| 13 |
Returns the Unicode character based on the number code. |
| 14 |
Returns the position of a pattern in a string. |
| 15 |
Returns a string with a delimiter |
| 16 |
Returns a new string by replacing all the occurrences of the particular part of a string (substring) with a specified string. |
| 17 |
Returns the repeated value. |
| 18 |
Returns a reversed string. |
| 19 |
Returns the rightmost characters from the actual(current) string. |
| 20 |
Returns a string after removing all trailing blanks. |
| 21 |
Returns the Soundex string. |
| 22 |
returns a string consisting of N number of space characters. |
| 23 |
Returns a number as string. |
| 24 |
Concatenates the values of string expressions and places separator values between them. |
| 25 |
Splits a string into rows of substrings. |
| 26 |
Returns a new string by inserting the second expression at the specified deleted place. |
| 27 |
Returns the part of the character. |
| 28 |
Returns a string from the first argument. |
| 29 |
Returns a trimmed string. |
| 30 |
Returns an integer value of the first character. |
| 31 |
returns a string that has all the characters in upper case. |
Khóa học lập trình tại Toidayhoc vừa học vừa làm dự án vừa nhận lương: Khóa học lập trình nhận lương tại trung tâm Toidayhoc
