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 Rhinorhino 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
Joined
Mar 21, 2006
Messages
5
Location
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