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?
Check if the value is a number or not
Moderators: chulett, rschirm, roy
Check if the value is a number or not
Thanks and Regards!!
dspxlearn
dspxlearn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: