How can I remove first 4 characters from a column on the result ? Can I use distinct for this column ?
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.
Love it . . Thank you . .
I am using the same expression with x.column name from table name 'x'. Not seems to be working
Any suggestions ?
Error ? or does not remove ?
Show us your query
Well .. It is working, Sorry about that (my bad)