Hello,
I have a query whith a column "Zone codes" which is populated with numbers. In this query, on an other column I put a sql code so that only the first digit of the numbers in the column "Zone codes" would appear. This column, named "binary", only has numbers 0 and 1.
What I need now is to populate an other column "UTM code" in this query with values BB or CB based on whether the column "binary" has 0 or 1. As the column "binary", this column "UTM code" is not linked to any table. It is just a column in the query.
Can anyone please tell me how to do this?
Thank you in advance
Best wishes
Carlos