Returns the last length characters from the string z. Example: RIGHT(z,length) SELECT RIGHT('Notebook',4) = 'book' Removes trailing blanks of the string z. Example: RTRIM(z) SELECT RTRIM('Notebook ') = 'Notebook' Returns a four-character SOUNDEX code to determine the similarity SOUNDEX(a) between two strings. Example: SELECT SOUNDEX('spelling') = S145 Returns a string with spaces of length specified by length. Example: SELECT SPACE = ' ' Converts the specified float expression f into a string. len is the length of the string including decimal point, sign, digits, and spaces (10 by default), and STR(f,[len [,d]]) d is the number of digits to the right of the decimal point to be returned. Example: SELECT STR(3.45678,4,2) = '3.46' Replaces the partial string z1 with the partial string z2 starting at position a, replacing length characters of z1. Examples: STUFF(z1,a,length,z2) SELECT STUFF('Notebook',5,0, ' in a ') = 'Note in a book' SELECT STUFF('Notebook',1,4, 'Hand') = 'Handbook' Creates a partial string from string z starting at the SUBSTRING(z,a,length) position a with a length of length.
RIGHT(z,length) Returns the last length characters from the string z. Example: SELECT RIGHT('Notebook',4) = 'book' RTRIM(z) Removes trailing blanks of the string z. Example: SELECT RTRIM('Notebook ') = 'Notebook' SOUNDEX(a) Returns a four-character SOUNDEX code to determine the similarity between two strings. Example: SELECT SOUNDEX('spelling') = S145 Returns a string with spaces of length specified by length. Example: SELECT SPACE = ' ' STR(f,[len [,d]]) Converts the specified float expression f into a string. len is the length of the string including decimal point, sign, digits, and spaces (10 by default), and d is the number of digits to the right of the decimal point to be returned. Example: SELECT STR(3.45678,4,2) = '3.46' STUFF(z1,a,length,z2) Replaces the partial string z1 with the partial string z2 starting at position a, replacing length characters of z1. Examples: SELECT STUFF('Notebook',5,0, ' in a ') = 'Note in a book' SELECT STUFF('Notebook',1,4, 'Hand') = 'Handbook' SUBSTRING(z,a,length) Creates a partial string from string z starting at the position a with a length of length.
1.0%20SQL-SERVER_Notes.docx