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: [email protected]
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
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
