I need help parsing a field in my SQL Server database. Sample of the data that I am trying to parse is as follows:
I want to parse the field so that it returns all the characters left of the asterisk, the asterisk, and only 2 characters right of the asterisk. The above sample data should look as follows after it's been parsed:
How can I do this?
Thanks in advance,