select query return "text" instead of "boolean value"

Hello,



it's been a long time since i did some SQL queries on MS Access, but i forgot how to do to return a text for each row (as field value) when a table field contains "1" as value ?

for example i have a table named "products" with a field/column called "promotion". Sometime a product is promotional, so in this case, the "promo" column holds "1" as value.



during a select on products table, how can i do to return "in promotion" (e.g.) if the column "promo" holds "1" for a product ?



thx.

select query return "text" instead of "boolean value"