Is there a way to create a query element that will format the phone number with parenthesis and dashes? I know this can be done in Excel but is there anyway to export with the format?
Thanks,
Elizabeth Carlock
I suspect you can't call database functions from an Output Set Element. But you could create a view (called something like LVS_FORMATTED_PHONE) that uses AF_FORMAT_STRING so that the database returns a formatted phone number to the output set.