Hi Ian, Well, I'd use something like fieldname LIKE *John*, but then I might be missing the point. Good luck with the other questions Heinrich (Salzburg-Austria)
On Tue, 19 Jul 2011 17:53:29 +0200, Ian Whitfield <[email protected]> wrote:
Hi All A question - Am I being stupid or asking to simple questions or am I just asking questions that can't be answered or that nobody has the answers for, or can be bothered to reply to?? My last three questions to the list have gone un-responded to!! On Jun 27 I asked about Subforms and Photos. On Jun 30 I asked about combining fields And on Jul 17 I asked about Queries. I really wonder why I get no replies. Any suggestions?? _A new question_ - I know and use the 'Like' statement when searching my Database but wonder if there are other Statements like this? I could really use one the looks for a string _within_ the field. Does one exist? ie if a Member's eMail address is "[email protected]" I would like to look for all addresses that have 'John' _within_ them. Thanks - I look forward to some replies (good or bad). Ian Whitfield ////
-- Erstellt mit Operas revolutionärem E-Mail-Modul: http://www.opera.com/mail/ -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
