{"id":5327,"date":"2013-04-19T00:00:36","date_gmt":"2013-04-19T00:00:36","guid":{"rendered":"http:\/\/craftydba.com\/?p=5327"},"modified":"2017-10-08T16:28:26","modified_gmt":"2017-10-08T16:28:26","slug":"string-functions-right","status":"publish","type":"post","link":"https:\/\/craftydba.com\/?p=5327","title":{"rendered":"String Functions &#8211; RIGHT()"},"content":{"rendered":"<p><a href=\"https:\/\/craftydba.com\/wp-content\/uploads\/2013\/04\/turquoise-yarn-md.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-thumbnail wp-image-5158\" title=\"turquoise-yarn-md\" src=\"https:\/\/craftydba.com\/wp-content\/uploads\/2013\/04\/turquoise-yarn-md-150x150.png\" alt=\"\" width=\"150\" height=\"150\" \/><\/a><br \/>\nI am going to continue my series of very short articles or tidbits on Transaction SQL string functions. I will exploring the RIGHT() function today.<\/p>\n<p>The <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms177532.aspx\">RIGHT()<\/a> function takes the source string [S] and number of characters [X] as input and returns the [X] rightmost characters from string [S] as output.<\/p>\n<p>The following example grabs the last word from a favorite movie title of mine.<\/p>\n<pre class=\"lang:TSQL theme:familiar mark:1,2-3\" title=\"string functions - right()\">\r\n-- Return last word\r\nselect right('wizard of oz', 2) as str_word\r\n<\/pre>\n<\/p>\n<pre class=\"lang:TSQL theme:epicgeeks\" title=\"output\">\r\noutput: \r\n\r\nstr_word\r\n-----------\r\noz\r\n<\/pre>\n<\/p>\n<p>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.<\/p>\n<pre class=\"lang:TSQL theme:familiar mark:1,2-3\" title=\"string functions - right()\">\r\n-- Invalid length\r\nselect right('wizard of oz', -1) as str_word\r\n\r\n-- Empty returns empty\r\nselect right('', 2) as str_word\r\n\r\n-- Null returns Null\r\nselect right(NULL, 6) as str_word\r\n<\/pre>\n<\/p>\n<pre class=\"lang:TSQL theme:epicgeeks\" title=\"output\">\r\noutput: \r\n\r\nMsg 536, Level 16, State 1, Line 2\r\nInvalid length parameter passed to the right function.\r\n\r\nstr_word\r\n--------\r\n\r\nstr_word\r\n--------\r\nNULL\r\n<\/pre>\n<\/p>\n<p>Next time, I will be exploring the <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms178660.aspx\">RTRIM()<\/a> function.  <\/p>\n","protected":false},"excerpt":{"rendered":"<p>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. &#8212; Return last word select right(&#8216;wizard of oz&#8217;, 2) as str_word output: str_word &#8212;&#8212;&#8212;&#8211; oz One thing to always worry about when using TSQL functions&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[814],"tags":[31,15,826,815,29],"class_list":["post-5327","post","type-post","status-publish","format-standard","hentry","category-very-short-articles","tag-database-developer","tag-john-f-miner-iii","tag-right","tag-string-function","tag-tsql"],"_links":{"self":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/5327","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=5327"}],"version-history":[{"count":0,"href":"https:\/\/craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/5327\/revisions"}],"wp:attachment":[{"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=5327"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=5327"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=5327"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}