The "EVAL" function that someone else mentioned also should work. I've never used it personally so I forgot about that. :)
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber Sent: Wednesday, May 30, 2007 1:52 PM To: u2-users@listserver.u2ug.org; u2-users@listserver.u2ug.org Subject: RE: [U2] unibasic select woes Thanks Karen! Is there really no other way? Seems odd that you can't use functions in the select statement. Greg At 12:42 PM 5/30/2007, Karen Bessel wrote: >Create a new dictionary item with conversion code 'MCU' pointing at the >same attribute#. Use that dictionary item in your select. > > > >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber >Sent: Wednesday, May 30, 2007 1:28 PM >To: u2-users@listserver.u2ug.org >Subject: [U2] unibasic select woes > >How does one select alpha-numeric data from a unidata datafile using >SELECT when the case of the text is not known? > >I have tried things like: >SELECT HRPER WITH UPCASE(HRP.LAST.NAME) LIKE 'SC...' >but all I get is a syntax error. > >Can someone tell me which function(s) can be used to facilitate this >type of search? > >Any help is greatly appreciated! > >Thank you, >Greg >------- >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/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/