I have a MOSS 2007 list with a column which contains hundreds of business and city names. These names are text commonly with multiple words, such as "City of Austin". I have setup filtering and data view web parts to allow a page to display contents of the list based on a query string. All works well, except that I need to generate the query string based on that column with the example above. The URL of course cannot have those spaces, so I need to replace them.
Since Substitue is still not available, and Replace with Search won't work when the number or location of spaces is unknown, I need another solution. Isn't there some method that has been devised to handle this situation?