Pssst... "MIAMI"
Also, I'm missing something.
Why not just select where [Statename] <> 'ALL' ?
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills