I would like to create a prompt that USES a column value consisting of one character (i.e. 'S') that I wish to DISPLAY using a text string (i.e. 'Summary') for the one character equivalent in the database. I have been aiming in the direction of a CASE statement and a 2nd Query but am having no luck in getting the prompt to display without an error being thrown.
In your query for prompt, which has a dataitem returning single character data, add another dataitem and implement it with CASE WHEN .. END clause.In the comparison, compare the values of the dataitem name and all possible values of single charcter data and within 'THEN' include the description that you would like to have for that single character.
E.g.:
CASE Dataitem1 contain 'C'
THEN 'Correct'
ELSE 'Incorrect'
END :)