11.02 How to display one column data with a label I title
SYNTAX: select ledger-name as ledger from ledger-master;
RESULT: LEDGER cash account sales account
11.03 How to display title I label without conversion as uppercase and as we entered
Here an interesting aspect, we gave the title "ledger" in lower case letters, where as it displayed the tittle in upper case letters, If we want to get the title as we entered 1 typed then the title should be embedded by double-quotes,
SYNTAX: select ledger-name "ledger" from
ledger-master; RESULT: ledger