Focal Point
[SOLVED] If a MAX prefix is applied to an alphanumeric field...

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5317037226

July 30, 2012, 12:39 PM
gcarterIT
[SOLVED] If a MAX prefix is applied to an alphanumeric field...
..., what does the returned value represent?

Thanks.

This message has been edited. Last edited by: Kerry,


WebFOCUS 7.6
Windows, All Outputs
July 30, 2012, 01:31 PM
Francis Mariani
Try this (the answer is in the answer set!):

TABLE FILE CAR
SUM 
MIN.COUNTRY
MAX.COUNTRY
END



Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
July 30, 2012, 05:39 PM
Waz
As its a string, it will be according to the highest ASCII/EBCIDIC (Depending on the OS) value for each character from the left most to the right most position according to the format.

A little detailed ?


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

August 01, 2012, 01:26 PM
gcarterIT
Got it.
Thanks Francis and Waz.


WebFOCUS 7.6
Windows, All Outputs