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?
One solution is to add another dictionary item and uppercase it through
the conversion field of the dictionary item.
One of the great strengths (and weaknesses) of U2 is that you can have
multiple dictionary items defining the same data field. Which sometimes
makes it difficult to figure out what the data is supposed to look like,
but if organized properly lends itself to selecting and reporting.
--
Allen Egerton
aegerton at pobox dot com
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
