RE: [U2] Wondering why select is not working

2008-08-05 Thread Jon Wells
] [mailto:[EMAIL PROTECTED] On Behalf Of Larry Hiscock Sent: Friday, August 01, 2008 4:22 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Wondering why select is not working Because 8a is a pattern that matches 8 consecutive alpha characters. Try this instead: SELECT B10.COMMONAPP WITH ANY

RE: [U2] Wondering why select is not working

2008-08-02 Thread Trevor Fulton
-users@listserver.u2ug.org 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

RE: [U2] Wondering why select is not working

2008-08-01 Thread Larry Hiscock
Because 8a is a pattern that matches 8 consecutive alpha characters. Try this instead: SELECT B10.COMMONAPP WITH ANY AVAILABILITY LIKE '...8a...' Larry Hiscock Western Computer Services -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jon Wells Sent:

Re: [U2] Wondering why select is not working

2008-08-01 Thread Anthony W. Youngman
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