Need help with SQL Query

Hello,

I have a table that has a column in it called fed_id that keeps federal tax id or social security number for vendors.

What would be the best way to extract either and place them into a separate column one for Social Security and the other column for Tax ID.

Thanks,

Derek