ALIAS support in Select statement???

daman

New Member
Hi,

I am new to Progress. I created a Select statement in Progress with an ALIAS similar to Oracle, Access, etc and ran into a snag. Is there a similar function in Progress? If so, please provide an example. I need to use aggregate functions and have ColdFusion to retrieve them.

ie.
SELECT MAX(CUST_ID) AS 'CUSTOMERID' FROM CUSTOMERS

I greatly appreciate any helps
 
Back
Top