Left, right, mid, len , trim

SELECT store.full, InStr([full],”-“) AS dash, instr(full, “,”) as comma, Left([full],dash-1) AS StoreNum, mid(full,dash + 1 , comma – dash – 1) AS city, trim( right( full, len(full) – comma)) as state FROM store;