I am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the RIGHT() function today. The RIGHT() function takes the source string [S] and number of characters [X] as input and returns the [X] rightmost characters from string [S] as output. The following example grabs the last word from a favorite movie title of mine.
|
1 2 |
-- Return last word select right('wizard of oz', 2) as str_word |
|
1 2 3 4 5 |
output: str_word ----------- oz |
One thing to always worry about when using TSQL functions is how will it react with empty strings, NULL values, or invalid values?…