Good Question but still I have doubts in some cases like:
SELECT ISNUMERIC('.+') -- Returns 0
SELECT ISNUMERIC('+.') -- Returns 1
SELECT ISNUMERIC (',\') -- Returns 0
SELECT ISNUMERIC ('\,') -- Returns 1
:ermm:
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/