[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.