I have a online system which users enter in information into text boxes. The information is stored in an mssql server database. As users enter in their information they are leaning on the space bar somehow and the result is having too many spaces between the words. I was wondering if there is a sql function/query I can execute to remove these unwanted spaces? Also, the online system is coded using ASP, can I remove the unwanted spaces between words before inserting/updating to the mssql server table?