Firstly: UK postcodes usually start with two letters indicating the area,
so for example if I'm looking for Leeds addresses I can filter these with a
query like:

SELECT * FROM ADDLIST.DBF  WHERE ADDLIST.DBF."POSTCODE"  LIKE "LS%" ;

However, some cities (e.g. Sheffield) have postcodes that start with a
single letter before digits. I would like to use a query like

SELECT * FROM ADDLIST.DBF WHERE ADDLIST.DBF."POSTCODE" LIKE "S[1-9]%";

to pick these out, but it doesn't work because "S[1-9]%" gets treated as a
literal, and the query doesn't find any postcodes. Anyone know a way round
this?

Secondly: can any helpful soul tell me how to extend this query into MEMO
fields?

  SELECT *
  FROM "ADDLIST.DBF"
  WHERE (SUBSTRING(POSTCODE FROM 1 FOR 1) = "S") AND
    (SUBSTRING(POSTCODE FROM 2 FOR 1) IN ("1", "2", "3", "4", "5", "6",
    "7", "8", "9", "0"))

It worked! although not quite as concise as it would be
in an ideal world..
Thanks, Steve. And greetings from halfway between Leeds
and Sheffield , U.K.