Left, Right, 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;