My 2 cents: http://codecorner.galanter.net/2009/04/03/tsql-isnumeric-function-returns-false-positives/[/url]

A UDF to determine if passed expression is a number indeed.