Check if the value is a number or not
Posted: Thu Aug 07, 2008 5:18 am
I have a field which can have values like '111.00','12','aaa'.
This field is defined as varchar field. I have to check if this field is a positive real numbers or not.
For values like '111.00','123.56' and '12' - i can convert into decimal values and can use the condition '>0'.
So, my concern is if i get a value like 'aaa', how do i check it?
This field is defined as varchar field. I have to check if this field is a positive real numbers or not.
For values like '111.00','123.56' and '12' - i can convert into decimal values and can use the condition '>0'.
So, my concern is if i get a value like 'aaa', how do i check it?