This should be simple but I have had no luck finding it. I want to convert a character field with ********* to ***-XX-***X.
I know I could use substring and length commands and concatenate, but this is pretty complicated. I think a format function will do this, I just have not found it.