I have a query where I need to have the SSN appears as 123456789 instead of
123-45-6789 can someone help me with this? The table has it as 123-45-6789.
I would like to do it without running an update query with the replace
function and would also like to avoid using left,mid,right if at all
possible.