I have a combo box with the follow:
GROUP BY Strings.Claimant
ORDER BY Strings.Claimant;
The problem is we want to the select the Claimant but their last name , however Claimant is a single column with firstname and last name. I would rather not have to change the tables design to have the first name and last name seperate, is there a way to do this?