RE: selecting data with 2 different data types

["DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>]

OY!  I can't believe it..... I've never used DIGITS() in SQL before.  I
bashed at this leading zeros problem for days without zeroing in on
DIGITS().  Thanks Buck, I feel really dumb right now. <G>

Eric DeLong
Sally Beauty Company
MIS-Sr. Programmer/Analyst
940-898-7863 or ext. 1863



-----Original Message-----
From: Buck Calabro [mailto:Buck.Calabro@commsoft.net]
Sent: Wednesday, March 13, 2002 3:54 PM
To: rpg400-l@midrange.com
Subject: RE: selecting data with 2 different data types


Giri Gopal wrote:
>I am select data from 2 different files.
>The where condition is comparing
>a.field with b.field.  A.Field is character
>10 long and B.Field is Numeric 6
>byte long. Can I convert B.field to a
>character before comparing to A.field
>with a substring 1 to 6 bytes?

Will this work?
where substr(a.field,1,6) = digits(b.field)

  --buck
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.