I think its because the 8a with a LIKE is interpreted as a pattern match, try the following
SELECT B10.COMMONAPP WITH AVAILABILITY = "[8a]" Trevor. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Anthony W. Youngman Sent: 01 August 2008 22:57 To: [email protected] Subject: Re: [U2] Wondering why select is not working In message <[EMAIL PROTECTED]>, Jon Wells <[EMAIL PROTECTED]> writes >Hi all, > >We have a file (Unidata 7.1) called B10.COMMONAPP where a MV'd attribute >called AVAILABILITY contains values representing a day and time. > >AE DICT B10.COMMONAPP AVAILABILITY >Top of "AVAILABILITY" in "DICT B10.COMMONAPP", 6 lines, 24 characters. >*--: P >001: D >002: 63 >003: >004: AVAILABILITY >005: 10L >006: M >Bottom. > >Example record --> > >063: >sun8a}mon8a}tue8a}wed8a}thu8a}fri8a}sat8a}sun830a}mon830a}tue830a}wed83 0a}th >u830a}fri830a}sat830a}sun9a}mon9a}tue9a}wed9a}thu9a}fri9a}sat9a}sun930a }mon9 >30a}tue930a}wed930a}thu930a}fri930a}sat930a}sun10a}mon10a}tue10a}wed10a }thu1 >0a}fri10a}sat10a}sun1030a}mon1030a}tue1030a}wed1030a}thu1030a}fri1030a} sat10 >30a}sun11a}sat11a}sun1130a}sat1130a}sun12p}sat12p}sun1230p}sat1230p}sun 1p}sa >t1p}sun130p}sat130p}sun2p}sat2p}sun230p}sat230p}sun3p}sat3p}sun330p}sat 330p} >sun4p}sat4p}sun430p}sat430p}sun5p}sat5p}sun530p}sat530p}sun6p}sat6p}sun 630p} >mon630p}tue630p}wed630p}thu630p}fri630p}sat630p}sun7p}mon7p}tue7p}wed7p }thu7 >p}fri7p}sat7p}sun730p}mon730p}tue730p}wed730p}thu730p}fri730p}sat730p}s un8p} >mon8p}tue8p}wed8p}thu8p}fri8p}sat8p}sun830p}mon830p}tue830p}wed830p}thu 830p} >fri830p}sat830p >Bottom. > >Can anyone tell us why -> >SELECT B10.COMMONAPP WITH AVAILABILITY LIKE "...8a..." > >Produces-> > >No data retrieved from current (S)SELECT statement. > >Thanks, > The SELECT isn't doing what you think ... What you need is SELECT B10.COMMONAPP WITH AVAILABILITY LIKE "...'8a'..." Note the single quotes around the '8a' What you've actually asked for is any AVAILABITY that contains an 8-alpha string. I got bitten by that *many* years ago ... I've always remembered it ... Cheers, Wp; -- Anthony W. Youngman <[EMAIL PROTECTED]> 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - <http://www.maverick-dbms.org> Open Source Pick ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ -------------------------------------------------------- Epicor Software (UK) is a limited company registered in England & Wales. Registration Number: 2338274. Registered Office: Osborne Clarke OWA, One London Wall, London EC2Y 5EB This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses. Any views and/or opinions expressed in this e-mail are of the author only and do not represent the views of Epicor Software (UK) Limited or any other company within its group. ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
