Re: [U2] unibasic select woes

[Martin Phillips]

Hi Greg,

Create a dictionary item named, for example, U.HRP.LAST.NAME, and defined as
001: I
002: UPCASE(HRP.LAST.NAME)

Fields 3 onwards as for HRP.LAST.NAME

Then do
 SELECT HRPER WITH U.HRP.LAST.NAME LIKE 'SC...'

Alternatively, do
 SELECT HRPER WITH EVAL "UPCASE(HRP.LAST.NAME)" LIKE 'SC...'


Martin Phillips, Ladybridge Systems Ltd
-------
u2-users mailing list
u2-users@listserver.u2ug.org
To unsubscribe please visit http://listserver.u2ug.org/