MQSeries.net :: View topic - [Solved] SELECT MAX of a VARCHAR

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » [Solved] SELECT MAX of a VARCHAR

[Solved] SELECT MAX of a VARCHAR

« View previous topic :: View next topic »

Author

Message

elvis_gn

Posted: Thu Aug 04, 2005 3:20 am Post subject: [Solved] SELECT MAX of a VARCHAR

Padawan

Joined: 08 Oct 2004
Posts: 1905
Location: Dubai

Hi,
I have a select statement which picks up a Row Id. The dumb thing is that the client database has the RowId as VARCHAR,

So When I do a "SELECT MAX(ROW_ID)......." it considers 9 to be the MAX value of VARCHAR and not 10 or anything bigger.

Is there a way I can do this. I did a PASSTHRU but have ended up with creating an ArrayList for RowId....It looks like a big mess...

Is there a way within ESQL to fetch the MAX

Last edited by elvis_gn on Thu Aug 04, 2005 10:40 pm; edited 1 time in total

jefflowrey

Posted: Thu Aug 04, 2005 3:27 am Post subject:

Grand Poobah

Joined: 16 Oct 2002
Posts: 19981

Did you consider embedding a CAST in your Select?

Why not?
_________________
I am *not* the model of the modern major general.

elvis_gn

Posted: Thu Aug 04, 2005 10:39 pm Post subject:

Padawan

Joined: 08 Oct 2004
Posts: 1905
Location: Dubai

Hi,
Thanks a lot, it works like a charm. A small desc.of the problem:

SELECT MAX(T.ROW_ID) FROM Database.ACCOUNT_I AS T WHERE T.IF_ROW_BATCH_NUM = 310101000

As suggested by jefflowrey, my new statement becomes:

SELECT MAX(CAST(T.ROW_ID AS INTEGER)) FROM Database.ACCOUNT_I AS T WHERE T.IF_ROW_BATCH_NUM = 310101000

Thanks again.

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » [Solved] SELECT MAX of a VARCHAR

Jump to:

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Protected by Anti-Spam ACP