I would suggest using ISNUMERIC, however it has several disadvantages that can lead one to a false conclusion.
I would suggest that you read the following article by Jeff Moden to determine to see if it is helpful.
http://www.sqlservercentral.com/articles/IsNumeric/71512/
If everything seems to be going well, you have obviously overlooked something.
Ron
Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]