Thank you everyone for responding... After seeing this response I had to look it up in the "Uniquery Commands Reference" manual. I did not know that the UniQuery "LIKE keyword" was a synonym for MATCH.
*-----------------------------------------------------------* Jon Wells Database Administrator Beloit College Information Services & Resources Beloit, Wisconsin 608-363-2290 [EMAIL PROTECTED] 608-363-2100 (fax) *-----------------------------------------------------------* -----Original Message----- From: [EMAIL PROTECTED] [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 AVAILABILITY LIKE '..."8a"...' Larry Hiscock Western Computer Services -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jon Wells Sent: Friday, August 01, 2008 11:36 AM To: u2-users@listserver.u2ug.org Subject: [U2] Wondering why select is not working 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}wed830a}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}sun1p}sa t1p}sun130p}sat130p}sun2p}sat2p}sun230p}sat230p}sun3p}sat3p}sun330p}sat330p} sun4p}sat4p}sun430p}sat430p}sun5p}sat5p}sun530p}sat530p}sun6p}sat6p}sun630p} mon630p}tue630p}wed630p}thu630p}fri630p}sat630p}sun7p}mon7p}tue7p}wed7p}thu7 p}fri7p}sat7p}sun730p}mon730p}tue730p}wed730p}thu730p}fri730p}sat730p}sun8p} mon8p}tue8p}wed8p}thu8p}fri8p}sat8p}sun830p}mon830p}tue830p}wed830p}thu830p} 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, *-----------------------------------------------------------* Jon Wells Database Administrator Beloit College Information Services & Resources Beloit, Wisconsin 608-363-2290 [EMAIL PROTECTED] 608-363-2100 (fax) *-----------------------------------------------------------* ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/