T-SQL Substring - Last 3 Characters

Question

Using T-SQL  how would I go about getting the last 3 characters of a varchar column   So the column text is IDS ENUM Change 262147 190 and I need 190

User · Answer

You can use either way   SELECT RIGHT RTRIM columnName   3    OR  SELECT SUBSTRING columnName  LEN columnName -2  3

User · Answer

Because more ways to think about it are always good   select reverse substring reverse columnName   1  3

User · Answer

SELECT RIGHT column  3    That s all you need   You can also do LEFT   in the same way   Bear in mind if you are using this in a WHERE clause that the RIGHT   can t use any indexes

User · Answer

if you want to specifically find strings which ends with desired characters then this would help you     select   from tablename where col name like   190

User · Answer

declare  newdata varchar 30  set  newdata  IDS ENUM Change 262147 190  select REVERSE substring reverse  newdata  0 charindex     reverse  newdata           Explanation      I found it easier to read written like this   SELECT     REVERSE  --4          SUBSTRING  -- 3              REVERSE  lt field name gt                0              CHARINDEX  -- 2                    lt your char of choice gt                    REVERSE  lt field name gt   -- 1                                FROM      lt table name gt     Reverse the text Look for the first occurrence of a specif char  i e  first occurrence FROM END of text   Gets the index of this char Looks at the reversed text again  searches from index 0 to index of your char  This gives the string you are looking for  but in reverse Reversed the reversed string to give you your desired substring

[sql] T-SQL Substring - Last 3 Characters

Examples related to sql

Examples related to sql-server

Examples related to sql-server-2005

Examples related to tsql