Split one field into two fields

Hi!  I have a field in a MSSQL2000 database that is actually three
fields.
Sample data:
billing3
Toccoa, GA 30577

I would like to run a query like this:
select [something] as city, [something] as state, [something] as zip

Can you fill in the [something]'s for me?

Thanks,

Matthew