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 alsoCode:SELECT phCode, phAlias, phXCode, phDialingCode+'-'+phPhoneNumber AS Phone FROM tblPhone;
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![]()




I use Visual Studio 2005 and code in VB.Net and C# and ASP.NET, as well as Crystal reports
Reply With Quote