Re: SQL RegExp (LIKE)

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

No, unfortunately, regular expressions are not supported by SQL.

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"Those who would give up essential Liberty,
  to purchase a little temporary Safety,
  deserve neither Liberty nor Safety."

     - The Papers of Ben Franklin

-----Original Message-----
From: Cardinale Mario <mcardinale@Natuzzi.com>
To: 'MIDRANGE-L@midrange.com' <MIDRANGE-L@midrange.com>
Date: Tuesday, January 30, 2001 10:50 AM
Subject: SQL RegExp (LIKE)


>
>Someone knows if is it possible to use RegExp in SQL/400 ?
>
>For example:
>
>Can i use this expression
>
>SELECT * FROM TABLE1 WHERE FIELD1  LIKE '1[4 5]0%'
>
>instead of
>
>SELECT * FROM TABLE1 WHERE FIELD1  LIKE '140%' or FIELD1 LIKE '150%'
>
>Thanks in advance for your attention.
>
>Mario Cardinale
>M.I.S.
>
>Industrie Natuzzi S.p.A.
><http://www.natuzzi.com/>
>The italian way to say sofa.
>
>This message is confidential; its contents do not constitute a commitment
by
>Industrie Natuzzi S.p.A. except where provided for in a written agreement
>between you and Industrie Natuzzi S.p.A. Any unauthorised disclosure, use
or
>dissemination, either whole or partial, is prohibited. If you are not the
>intended recipient of the message, please notify the sender immediately.
>
>
>
>
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator:
david@midrange.com
>+---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---