Can anyone think of a real world use for a wildcard statement like this LIKE '%a%b%c%d%'
It's in the Ben Forta study guide and it came up in a drinking session that there wasn't a real use for this sort of thing. Seaching for strings in a particular order in a larger string would be one, but are there any other ways to do this, faster or slower. Any ideas? :O) Adrian Lynch ---------------------- United Kingdom http://www.thoughtbubble.co.uk/ Ph: +44 (0) 20 7387 8890 ---------------------- New Zealand http://www.thoughtbubble.co.nz/ Ph: +64 (0) 9 488 9131 The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s) . Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0) 20 7387 8890 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

