Remove first 4 characters from a column

jollyegeorge · December 4, 2015, 8:50pm

How can I remove first 4 characters from a column on the result ? Can I use distinct for this column ?

JamesK · December 4, 2015, 8:52pm

SELECT STUFF(YourColumn,1,4,'') FROM YOURTABLE

You can use distinct. The distinctness (or is it distinctivity ) will be based on result of the STUFF function - i.e, the values with the first 4 characters removed.

jollyegeorge · December 4, 2015, 9:13pm

Love it . . Thank you . .

jollyegeorge · December 8, 2015, 1:01am

I am using the same expression with x.column name from table name 'x'. Not seems to be working
Any suggestions ?

khtan · December 8, 2015, 1:43am

Error ? or does not remove ?

Show us your query

jollyegeorge · December 8, 2015, 4:20pm

Well .. It is working, Sorry about that (my bad)