replace(strYourString, " ","%") should do it.... > -----Original Message----- > From: Christine Breen [mailto:cbreen at usgs.gov] > > If the data (for example 'useful links') in the database > contains spaces, how can ASP check for spaces in the data > (useful links) and replace the spaces with a %