Hi Jeff,
I think this SELECT will work very slooow with big Loan.dbf.
>Thanks everybody. This is what I came up with after my post. It seems that I wasn't to far off. Thanks again!
>
>
>SELECT clender_loan_number,;
> PADR(ICASE(nborrower_number_of_employees >= 0 .and. nborrower_number_of_employees <= 9 , "0 - 9",;
> nborrower_number_of_employees >= 10 .and. nborrower_number_of_employees <= 24, "10 - 24",;
> nborrower_number_of_employees >= 25 .and. nborrower_number_of_employees <= 49, "25 - 49",;
> nborrower_number_of_employees >= 50 .and. nborrower_number_of_employees <= 99, "50 - 99",;
> nborrower_number_of_employees >= 100 .and. nborrower_number_of_employees <= 249, "100 - 249",;
> nborrower_number_of_employees >= 250 , "250 "),10) as cRange ,;
> ICASE(nborrower_number_of_employees >= 0 .and. nborrower_number_of_employees <= 9 , 1,;
> nborrower_number_of_employees >= 10 .and. nborrower_number_of_employees <= 24, 2,;
> nborrower_number_of_employees >= 25 .and. nborrower_number_of_employees <= 49, 3,;
> nborrower_number_of_employees >= 50 .and. nborrower_number_of_employees <= 99, 4,;
> nborrower_number_of_employees >= 100 .and. nborrower_number_of_employees <= 249, 5,;
> nborrower_number_of_employees >= 250 , 6) as nPrint_Order FROM loan
>
>
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
