http://www.sqlservercentral.com/Content tagged T-SQL, soundex posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)My client wants to standardize address information for existing and future addresses collected for their customers, particularly the street suffixes. The application used to enter and collect address information has the street suffix separated from the address field, but it is a textbox instead of a drop down list therefore things are not standardized. I know there are some options out there to standarize data, but they would like a less expensive alternative. Are there any functions in SQL Server that I can use to standardized data?

Make working with SQL a breeze SQL Prompt 5 is the effortless way to write, edit, and explore SQL. It's packed with features such as code completion, script summaries, and SQL reformatting, that make working with SQL a breeze. Try it now.

]]>http://www.sqlservercentral.com/redirect/articles/71708/Tue, 23 Nov 2010 07:00:00 UThttp://www.sqlservercentral.com/redirect/articles/71708/