RE: [U2] unibasic select woes

2007-06-01 Thread Morelli, David W.
5:10 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] unibasic select woes Greg, Actually the following in saver: SELECT HRPER WITH EVAL "OCONV(HRP.LAST.NAME,'MCU')" LIKE "'SC'..." (note the extra ' around the text) there are a few alphanumeric cha

[U2] unibasic select woes

2007-06-01 Thread Brian Whitehorn
You can use EVAL in your select to do what you want for the MCU ... +--- ---+ | | | EVAL | | | | _ | | | | | |Use in any RetrieVe sentence to introduce

RE: [U2] unibasic select woes

2007-05-31 Thread Dave Davis
Maybe that works in Universe, but it doesn't in UniData -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boydell, Stuart Sent: Wednesday, May 30, 2007 7:59 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] unibasic select woes SELECT HRPER

RE: [U2] unibasic select woes

2007-05-30 Thread Andre Meij
lts when you are not expecting that. Regards, Andre -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber Sent: maandag 30 april 2007 11:12 To: u2-users@listserver.u2ug.org; u2-users@listserver.u2ug.org Subject: RE: [U2] unibasic select woes Dav

RE: [U2] unibasic select woes

2007-05-30 Thread Boydell, Stuart
SELECT HRPER WITH HRP.LAST.NAME CONV "MCU" LIKE 'SC...' Should work. >-Original Message- >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...'

RE: [U2] unibasic select woes

2007-05-30 Thread Bruce McAdoo
essage- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber Sent: Wednesday, May 30, 2007 12: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

RE: [U2] unibasic select woes

2007-05-30 Thread Karen Bessel
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

RE: [U2] unibasic select woes

2007-05-30 Thread Greg Schraiber
put the word "SELECT" in lowercase to evaluate using the "u" parser. -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

Re: [U2] unibasic select woes

2007-05-30 Thread Allen Egerton
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

Re: [U2] unibasic select woes

2007-05-30 Thread 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...'

RE: [U2] unibasic select woes

2007-05-30 Thread Greg Schraiber
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 w

RE: [U2] unibasic select woes

2007-05-30 Thread Buffington, Wyatt
Try: SELECT HRPER WITH EVAL "UPCASE(HRP.LAST.NAME)" LIKE 'SC...' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Greg Schraiber Sent: Wednesday, May 30, 2007 12:28 PM To: u2-users@listserver.u2ug.org Subject: [U2] unibasic selec

Re: [U2] unibasic select woes

2007-05-30 Thread Jeff Schasny
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 dataf

RE: [U2] unibasic select woes

2007-05-30 Thread Karen Bessel
: 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.

RE: [U2] unibasic select woes

2007-05-30 Thread Dave Davis
ilto:[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

[U2] unibasic select woes

2007-05-30 Thread Greg Schraiber
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 thi