> 
> SELECT a.[PREMISES],a.[Class] FROM [Legacy].[dbo].[MyTables] as a;
> 
> 
> 

Above query returns :

[![enter image description here](https://i.stack.imgur.com/go4GO.jpg)](https://i.stack.imgur.com/go4GO.jpg)

Can you tell me how to remove `210,` and `211,` from the query column `a.[Class]` ?

**Note :** I just gave an example.I need to have a generic solution which will apply for all the rows of that `a.[Class]` column.

**Note 2 :** Format of the `Class` column is like this.`numeric` then `,` after that `string`.I need to remove first 2 parts.Need to keep only the `string` part.