Help! find values beginning with **

[hullstorage]

I am trying to create an expression of some sort
to find values in my postcode file

my postcode file consists of postcode like this

AB43 3WJ
AB1 1RU
etc... etc


i am trying to when results shown for AB* then i want something
where i can put "SCOTLAND" in the all AB* county fields

 

[rainman89]

you could do a

iif( [postcode] like "AB*", "Scotland", "Enter something in here for the false conditions")