RE: [sqr-users] Check for NUMERIC in field.

["George Jansen" <GJANSEN@aflcio.org>]

Just to hammer the obvious a little further into the ground:

1. One of the dogmas of the relational gurus is Thou Shalt Not Mix
Domains Within Attributes, or, in plain English, store like data with
like. If the ABCs and 999s are not equivalent, why are they in the same
column?

2. But if this is someone else's decision that has to be worked with,
and if table scans are a performance issue, well, why not create a
lookup table:

CREATE TABLE zero_through_999 (
  numeric_string VARCHAR2(3));

populate it, index it, and use a join?



>>> Steve.Alexander@ci.sj.ca.us 02/24/03 12:46PM >>>
Good point, I was assuming that the field was all numeric or all
alphabetic.

-----Original Message-----
From: Lynds,Rick [mailto:rlynds@mwdh2o.com] 
Sent: Monday, February 24, 2003 9:40 AM
To: 'sqr-users@sqrug.org' 
Subject: RE: [sqr-users] Check for NUMERIC in field.


Be careful... '1XX' is between '000' and '999'

-----Original Message-----
From: Alexander, Steve [mailto:Steve.Alexander@ci.sj.ca.us] 
Sent: Monday, February 24, 2003 9:38 AM
To: 'sqr-users@sqrug.org' 
Subject: RE: [sqr-users] Check for NUMERIC in field.


Now you tell us!  Try this:

WHERE TAB.FIELD BETWEEN '000' AND '999'

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users 

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org 
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users