Don't forget, if you run up against the limitations of the built-in types, you have the option of creating your own user-defined types.

Unfortunately, it does require CLR integration to be turned on and there is a performance hit.

See SQL Server 2005 Books Online

"CLR User-Defined Types"

Paste into IE (SQL2005 BOL installed):

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/denet9/html/27c4889b-c543-47a8-a630-ad06804f92df.htm

(online version)

http://msdn2.microsoft.com/en-us/library/ms131120.aspx