How should I format the phone number in sql?
HOW CAN I FORMAT THIS QUERY AS '+55 111 222 33 11'
SELECT CASE
WHEN SUBSTR (LTRIM (RTRIM (PPH.SEARCH_PHONE_NUMBER)), 1, 3) = '+55' THEN LTRIM (RTRIM ((PPH.SEARCH_PHONE_NUMBER))) WHEN SUBSTR (LTRIM (RTRIM (PPH.SEARCH_PHONE_NUMBER)), 1, 2) = '55' THEN '+' || LTRIM (RTRIM (PPH.SEARCH_PHONE_NUMBER)) ELSE '+55' || LTRIM (RTRIM (PPH.SEARCH_PHONE_NUMBER)) END
FROM PER_PHONES PPH
Thank you
Tagged:
0