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!

Register Log in
  • Congratulations Mike Lewis 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

croix18

Programmer
Mar 21, 2006
5
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.
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

trenttc
  • Locked
  • Question
UPPERCASE words only
Replies
1
Views
38
PDreyer
PDreyer
jwiebe
  • Locked
  • Question
Very slow Queries/Strange behaviour upon selecting fields
Replies
1
Views
52
mrmitchmitchell
mrmitchmitchell
aspijker
  • Locked
  • Question
usage device from data and log to only data
Replies
2
Views
59
aspijker
aspijker
crystalReporterNew
  • Locked
  • Question
indexing on 2 fields
Replies
1
Views
49
nikhilparchure
nikhilparchure
lazyrunner50
  • Locked
  • Question
DECLARE CURSOR must be the only statement in a query batch
Replies
0
Views
112
lazyrunner50
lazyrunner50

Part and Inventory Search

Sponsor

Back
Top