I have table in which has a column "active" and the values are either 'Y' or 'N'. But on the report i have to field called 'Status' which displays like 'Active' or 'Not active' but not 'Y' or 'N'.
In order to achieve this can i use "apply simple case statement REPLACE" with in the Status attribute and display 'Active' or 'Not Active' based on 'Y' or 'N' in the table?
I am not sure if we can do this.If not is there any other way we can achieve it?
Thank you.
In order to achieve this can i use "apply simple case statement REPLACE" with in the Status attribute and display 'Active' or 'Not Active' based on 'Y' or 'N' in the table?
I am not sure if we can do this.If not is there any other way we can achieve it?
Thank you.