Create an I-Type pointing to the text field that converts all the text to upper case and use it in the select
I-Type: UP.HRP.LAST.NAME 001: I 002: OCONV(HRP.LAST.NAME,'MCU') 003: 004: LAST NAME 005: 25L 006: S Greg Schraiber wrote: > 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 > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ > -- ------------------------------------------------------------------------ Jeff Schasny - Denver, Co, USA jschasnyATgmailDOTcom ------------------------------------------------------------------------ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
