Code:
SELECT phCode, phAlias, phXCode, phDialingCode+'-'+phPhoneNumber AS Phone
FROM tblPhone;
This is my current query which combines a dailing code and a phone number to create a complete number and now I need to rework this so that it will also
combine phCountryCode with phDialingCode+'-'+phPhoneNumber if phCountryCode <> 27 and <> "". If this statement is true then it must combine something like this phCountryCode+'-'+phDialingCode+'-'+phPhoneNumber but the first number of phDialingCode will always be a zero so I need the zero to be replaced with the phCountryCode if the if statement is true

Please help