What I have is 10 columns, each with 0-50 names that display, wrap around, etc. They have been strung together and separated by a ";". As requested. If a name has a "+" sign in front of it I need to turn that name blue, if it has an "*" I need to turn it blue... otherwise I leave it black. I am looking for a way to turn everything between each "+" and ";" blue (and there could be any number of these in a string) likewise with the red. Example
"Steve; +Robin;Mike; *David; +Shelia; BillyBob; Joseph;+Frank". I need +Robin, +Shelia, +Frank to be blue, David to be red and the rest the usual black. If at all possible I would like to keep the SQL as is (it works, runs fast, provides the customer what they want in the way they want it, and the code is very complex and long).