Ive been given a task to create a t-SQL query against a text column. Some of the values in this column contain an html code but there is also a human-readable text included.
E.g.: \color table; \yellow22\ blue45\gray112\; \yellow0\blue0\gray0; Email all admin accounts to john_doe@email.com
I dont need all this stuff. All I need is: Email all admin accounts to john_doe@email.com
So, how to extract just this human-readable text from coding text?