Re: Query Substr for numeric

I just gave you the answer...

substr(digits(mydat),2,3)

Digits turns the numeric value to character.


Michael Schutte
Admin Professional
Bob Evans Farms, Inc.
"The Secret's the Sauce! Enjoy our new Bob-B-Q Pulled Pork Knife & Fork
Sandwich!"


rpg400-l-bounces@xxxxxxxxxxxx wrote on 07/13/2007 12:06:32 PM:

Thank you, but I am not seeing how you can convert this in the HELP

available.

Jerry Adams <jerry@xxxxxxxxxxxxxxx> wrote: You can't substring
numerics. Convert it to a character first; then
substring that result.

* Jerry C. Adams
*IBM System i Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
615.995.7024
fax
615.995.1201
email
jerry@xxxxxxxxxxxxxxx



Mike Berman wrote:

HI I forget how to substriing a numeric I am looking to process

records by month in Query.

as in

MONTH SUBSTR(MYDAT, 2, 3)

MTIA,
Mike


---------------------------------
Got a little couch potato?
Check out fun summer activities for kids.

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.




---------------------------------
Be a PS3 game guru.
Get your game face on with the latest PS3 news and previews at Yahoo!

Games.

--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing

list

To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.