I am trying to display a route event, but because of leading, trailing or intermediate spaces in the route identifier I only get about a tenth of the events displaying. I am using a personal database and a route shape file, I can modify the personal database, but the problem is the inconsistancy in the shape file. Is there any way to remove the spaces like using a variable created with SQL somewhere like SELECT REPLACE(Route identifier, ' ','')? any help is greatly appreciated
... View more