Printable View
I have a field in an oracle db of datatype VARCHAR2(24) (alphanumeric)
I amy trying to extract records where the above field is a 6 digit numeric
e.g.
168497 I need this
568478 I need this
SWTA-HGT Don't need this
12476 Don't need this
In MS Access (gawdblessit), you can use the '#' wildcard to identify numerics. Any such wildcard in Oracle?
Cheers
s'OK, got my solution :D but not ideal:( . Any ideas on numeric wildcards still appreciated...
probably.
Is it my turn to pay for the Ramen?
How did the wedding go?
When do you want to eat?
Cheers,
P.
Probably????? You deserve to buy me Ramen after that Paul!!! I'm ready today if you like...
Have you tried the underscore character _ ?
The wildcard character in Oracle is the % sign.
The % character is for any number of characters though.
You are correct about that.
You are looking for a way to specifically identify field entries that are 6 numeric characters ONLY? Am I reading your question correctly?