Maximum and Minimum JOBNO in a project

ecclesr · Post by **ecclesr** » Wed Oct 18, 2006 4:39 pm

I am trying to find the minimum and maxium JOBNO is a project

SELECT MAX(JOBNO) FROM DS_JOBS;

Returns 999

But the actual number i was expecting was 2677 ??

Thanking you all in advance

ray.wurlod · Post by **ray.wurlod** » Wed Oct 18, 2006 4:52 pm

That's because JOBNO has a data type of VarChar. Try:

Code: Select all

SELECT MAX(CAST(JOBNO AS INTEGER)) FROM DS_JOBS;

or

Code: Select all

LIST DS_JOBS MAX JOBNO DET.SUP

kumar_s · Post by **kumar_s** » Wed Oct 18, 2006 7:38 pm

Ray - Everytime you give out some new stuff. May I know what 'DET.SUP' used in your query for. Is it to suppress the Description information?

chulett · Post by **chulett** » Wed Oct 18, 2006 7:53 pm

Detail Suppression. Run the query with and without and you shall see, my young Padawan.

Prashantoncyber · Post by **Prashantoncyber** » Wed Oct 18, 2006 8:55 pm

Can anybody suggest where (mean any pdf or doc) list of such kinds of commands can be found out.
thanks

ray.wurlod · Post by **ray.wurlod** » Wed Oct 18, 2006 11:25 pm

All the UniVerse manuals.

rameshrr3 · Post by **rameshrr3** » Thu Oct 19, 2006 2:23 am

Do a google on "Universe ODBC guide" and it will lead you to quite a few other useful documents.

HTH

Ramesh

kumar_s · Post by **kumar_s** » Thu Oct 19, 2006 3:20 am

chulett wrote:Detail Suppression. Run the query with and without and you shall see, my young Padawan.

Thats obvious from you, Jedi Master.

chulett · Post by **chulett** » Thu Oct 19, 2006 7:58 am

I defer that title to Ray... err, I mean Mr Wurlod.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 19, 2006 8:53 am

Unlike Yoda I don't put verbs at the ends of sentences. Unless in Latin, of course.