Browse by Tags

All Tags » isnumeric (RSS)

Enhanced ISNUMERIC() function

It seems often users want to check whether the data has only numbers in a varchar type column. The commonly suggested one is to make use of ISNUMERIC() function. But the problem in using that function is that it will treat some alphabets, $, char(10)...
Posted by Madhivanan | with no comments
Filed under: ,