At http://blog.sqlauthority.com/2011/09/21/sql-server-denali-14-new-functions-a-quick-guide/ there is an excellent article on functions that have been added to the next version of SQL Server. I like in particular the TryParse function that will allow a more controlled approach to loading numerical data that has been manually entered.