Toad World® Forums

Need help with SQL Query



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.