Here we go again, with the digest sending individual emails. Thanks, Jan
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2008 11:25 AM To: [EMAIL PROTECTED] Subject: U2 Users Digest V1 #2306 U2 Users Digest Tuesday, August 5 2008 Volume 01 : Number 2306 In this issue: RE: [U2] Wondering why select is not working ---------------------------------------------------------------------- Date: Tue, 5 Aug 2008 10:57:35 -0500 From: "Jon Wells" <[EMAIL PROTECTED]> Subject: RE: [U2] Wondering why select is not working 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}wed830 a}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}s at10 30a}sun11a}sat11a}sun1130a}sat1130a}sun12p}sat12p}sun1230p}sat1230p}sun1 p}sa t1p}sun130p}sat130p}sun2p}sat2p}sun230p}sat230p}sun3p}sat3p}sun330p}sat3 30p} sun4p}sat4p}sun430p}sat430p}sun5p}sat5p}sun530p}sat530p}sun6p}sat6p}sun6 30p} mon630p}tue630p}wed630p}thu630p}fri630p}sat630p}sun7p}mon7p}tue7p}wed7p} thu7 p}fri7p}sat7p}sun730p}mon730p}tue730p}wed730p}thu730p}fri730p}sat730p}su n8p} mon8p}tue8p}wed8p}thu8p}fri8p}sat8p}sun830p}mon830p}tue830p}wed830p}thu8 30p} 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/ ------------------------------ End of U2 Users Digest V1 #2306 ******************************* ------------ u2-users-digest 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/
