Happy Holidays to All!

How do I extract a concatenated field so I have exactly what I need. I've used the Left and Right functions, but I need to extract more precisely without having to guess the number of characters. For example:

New York, NY 10019 I want to extract out the "NY" or the state. How do I do that given I may have multiple city and states?

Thanks for any help