InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 08:39:53 GMT20http://www.sqlservercentral.com/Forums/Topic682549-8-1.aspxYou can use the STUFF or SUBSTRING functions as well as the RIGHT function. The SUBSTRING function version is likely to be the fastest, followed by the RIGHT version then the STUFF version.[code]DECLARE @value varchar(20)SELECT @value = 'ks105'SELECT STUFF(@value, 1, 2, '') AS [Stuff], SUBSTRING(@value, 3, 18) AS [Substring], RIGHT(@value, LEN(@value) - 2) AS [Right][/code]Tue, 24 Mar 2009 11:46:31 GMTandrewd.smithhttp://www.sqlservercentral.com/Forums/Topic682549-8-1.aspxLookup the RIGHT function in Books Online. To get the results you want, you may need to combine it with LEN to get all the string except the first two characters.Tue, 24 Mar 2009 10:23:44 GMTGilaMonsterhttp://www.sqlservercentral.com/Forums/Topic682549-8-1.aspxI am looking for a solution to a problem. I can't quite find the command I am looking for. I want to select from a column where the items in the column are like ks105ks103ks106and so onI want my results to produce the 105103106 and so on.I want my select command to drop the first 2 characters in that column when displaying the results. I do not want to modify the information in that table just want my select to display differently.Thanks in advanceRichtossTue, 24 Mar 2009 10:19:24 GMTRICHTER-311234