LIKE is a database operator and may not work with an external data source that is a flat file.
Wonder if this would work: Computername = "ES*" .just a shot in the dark --- J.T. Shyman _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Janie Sent: Tuesday, September 09, 2008 10:36 AM To: [email protected] Subject: Re: AIE Flatfile External Vendor Query I did try that as well. It doesn't pick anything up. If I do Computername = "ESxxx" that works. It just seems that the LIKE qualifier will not find any rows. Any more ideas? Thanks, Janie _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Zainub Gaffoor - BCX Sent: Tuesday, September 09, 2008 12:43 AM To: [email protected] Subject: Re: AIE Flatfile External Vendor Query ** Hi Janie, Try using double quotes. i.e. Computername like "ES%" Hope that helps :-) From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Janie Sent: 09 September 2008 06:12 AM To: [email protected] Subject: AIE Flatfile External Vendor Query ** Hi, Does anyone have a sample of an AIE Flatfile External Data Store Query ? I am using a Like statement but it isn't limiting the key data... Computername like 'ES%' Does anyone see anything wrong with that statement? Computername is coming from the flatfile. It's been selected from the External Data Store Fields. Thanks, Janie <mailto:[EMAIL PROTECTED]> __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ Important Notice: This e-mail and its contents are subject to the Business Connexion (Pty) Ltd e-mail legal notice available at: http://www.bcx.co.za/disclaimer.htm __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
