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