Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Numeric Only Fields

Status
Not open for further replies.

croix18

Programmer
Mar 21, 2006
5
0
0
US
I was wondering, is there a way to tell if a field contains only numeric characters? I have to exclude numeric fields and keep alpha-numeric values for the select statment. I've looked into LIKE and NOT LIKE but do not think they will do the job.

I am attempting this at first using Business Objects because it's quicker, but I can move it over to Rapid SQL if needed.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top