Firstly this is similar to If-Then Label Expression BUT I need this for Mapinfo.
So I want to do the following in Mapinfo in the label expression box in ver 12.
if RuralAdd='R': address=St_No + " ; " + LotPlan else address=St_No
Is this possible? without creating a new column with this info using SQL.
===== @T_Bacon suggested I get the following but the lots with 0 St_No_1 still get a O in it. My code is