Thanks to Robert Crossley and Silke Keuerleber who both suggested:- Select * from SOME_TABLE where instr(1,SOME_FIELD,"20%")>0
Which does the job. Thanks, Keith This email and any attached files are confidential and copyright protected. If you are not the addressee, any dissemination of this communication is strictly prohibited. Unless otherwise expressly agreed in writing, nothing stated in this communication shall be legally binding. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12321
