String Functions – RIGHT()

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.

One thing to always worry about when using TSQL functions is how will it react with empty strings, NULL values, or invalid values? Both empty strings and NULL values as inputs return themselves as outputs. A negative number for input [X] will result in a error being throw.

Next time, I will be exploring the RTRIM() function.

Related posts

Leave a Comment