Home » RDBMS Server » Server Administration » numeric validation
numeric validation [message #370161] Tue, 26 December 2000 13:29 Go to next message
mike kramer
Messages: 1
Registered: December 2000
Junior Member
How do you check a varchar field to see if all the values are numeric. Similar to the ISNUMERIC tests in other languages.

Report message to a moderator

Re: numeric validation [message #370195 is a reply to message #370161] Sat, 30 December 2000 12:30 Go to previous message
Robert Moy
Messages: 15
Registered: December 2000
Junior Member
Hello Mike:

Try use To_Number to convert items in your varchar field to see if they are numbers.

Report message to a moderator

Previous Topic: problem with trigger and commit
Next Topic: Counting No of DML operations
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 21:16:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.