IF() Funktion used in Report

[marcus]

Hello
i would like to use a IF() Function inside a report, to translate a table made of 1 and 0 into Yes and No. I tried using aliases in the table.
Unfortunatly

Code: Select all

SELECT IF(test_data = 1, "Yes, "No") AS word FROM table_test

is not working while

Code: Select all

SELECT test_data AS word FROM table_test

is working fine, when using a field calles 'word' inside the report.
How could I achieve my goal?
Best regards
marcus

[kev1n]

I think you will have to create a Procedure. This allows you to use complex queries.