[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
Q: IsNumeric-function ?
- Subject: Q: IsNumeric-function ?
- From: WDFI-F KyttÈa Timo <TIMO.KYTTA@VAASA.WARTSILA.INFONET.COM>
- Date: Wed, 3 Jul 1996 09:17:00 GMT-0200
- Original-Encoded-Information-Types: IA5-Text
- P1-Message-ID: FI*INFONET*WARTSILA;960703111716
- P1-Recipients: SQR-USERS@USA.NET
- Priority: normal
- UA-Content-ID: CSI NC V3.0
- X400-Trace: FI*INFONET*WARTSILA; Arrival 3 Jul 96 09:17 GMT-0200 Action: Relayed
- X400-Trace: us*infonet*; Arrival 3 Jul 96 06:17 GMT Action: Relayed
Hello everybody!
I joined in this list yesterday and now I already have a
good (?) question.
We use SQRWB/3.0.7.0.1 in Sun/Solaris & Oracle 7.1 and I
needed to check in my program if first character in field
is numeric or not.
At first I tried to look in SQR-functions, but found nothing
to this purpose. Then I tried to do it in SQL, but couldn't think
of anything else but ugly decode(substr(field,1,1),1,'YES',2, ....
Does anybody know any way to do this easier in SQR or in Oracle SQL?
Thanks in advance
Timo
timo.kytta@vaasa.wartsila.infonet.com
http://www.pcuf.fi/~tik
'reality is for people, who cannot ////
cope with science fiction ' (o o)
-------------------------------------o00=(_)=00o---