Change information in a query

[calobo]

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

[recyan]

Am I missing something :

SELECT 
	myTable.ZoneCode, 
	Left([ZoneCode],1) AS [Binary], 
	IIf([Binary]=0,"BB","CB") AS UTM
FROM 
	myTable;

Thanks

[alansidman]

ignore this response. I posted in error.

[calobo]

Worked just fine.

Thank you very much

Carlos