I have a web app with a combo box that fills from a database column. In the database, some items have two spaces in places, i.e. the one I'm dealing with:
Tape Measure--Power Lock
where -- indicates 2 spaces. So of course in the webform dropdownlistbox, the two spaces are truncated to one as for all web stuff. Now when I look in the database from the chosen value in the dropdownlistbox, the two don't match up. Is there any simple way to do this before I have to write some program to wax all double spaces in the database?