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: firstname.lastname@example.org +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.