T-SQL GO statement

Using SOUNDEX and DIFFERENCE to Standardize Data in SQL Server

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?

Get column names in a table

Script to get a table's columns

temp table in sysobjects

SELECT INTO with a Temp Table

Conditional Order By

Sorting Months By Number (SQL Spackle)

Fill in another bit of your T-SQL knowledge by learning how to sort a result set by the proper month order, but use the month name instead.

COALESCE Vs ISNULL

To switch or not to switch

More of computed columns