Please try the following test. Using RRBYW14 database and querying the invoicedetail table. The intent is to display: 'U' for discounts under 10 'O' for discounts over 10 'E' for discounts equal to 10 Version: R:BASE v8.0 for Windows (32-bit), U.S. Version, Build: 8.0.22.31225 This displays properly: SELECT DISCOUNT,(IFLT(discount,10,'U',(IFGT(discount,10,'O','E')))) FROM invoicedetail However, this displays null: BROWSE DISCOUNT,(IFLT(discount,10,'U',(IFGT(discount,10,'O','E')))) FROM invoicedetail But, if two characters are used both commands display properly: SELECT DISCOUNT,(IFLT(discount,10,'UV',(IFGT(discount,10,'OV','EQ')))) FROM invoicedetail BROWSE DISCOUNT,(IFLT(discount,10,'UV',(IFGT(discount,10,'OV','EQ')))) FROM invoicedetail Single character results in the BROWSER are always shown as null whereas more than one character displays the proper value. Am I overlooking something? Thanks -- Mike Ramsour
Confidentiality Notice This message is intended exclusively for the individual or entity to which it is addressed and may contain privileged, proprietary, or otherwise private information. If you are not the named addressee, you are not authorized to read, print, retain, copy or disseminate this message or any part of it. If you have received this message in error, please notify the sender immediately by e-mail and delete all copies of the message.
