Browse by Tags

All Tags » isnumeric » sql server (RSS)
Sorry, but there are no more tags available to filter with.

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: ,