Show every customer even if mobile in null

[Simon]

I have the following query that shows mobile number for any customer

Is there a way it to dispay ever customer number and if the customer
does not have a mobile number its left black

SELECT tblCustomers.CustomerNumber, Replace([PhoneNumber], " ", "") AS
Mobile
FROM tblCustomers
WHERE [PhoneNumber] LIKE "07*"

Union
SELECT tblCustomers.CustomerNumber, Replace([MobileNumber], " ", "")
AS Mobile
FROM tblCustomers
WHERE [MobileNumber] LIKE "07*"

 

[Arvin Meyer [MVP]]

How about:

SELECT tblCustomers.CustomerNumber, Replace([PhoneNumber], " ", "") AS
Mobile
FROM tblCustomers
WHERE [PhoneNumber] LIKE "07*";
UNION
SELECT tblCustomers.CustomerNumber, Replace([MobileNumber], " ", "") AS
Mobile
FROM tblCustomers;

 

[KARL DEWEY]

Maybe like this --
SELECT tblCustomers.CustomerNumber, IIF([MobileNumber] LIKE "07*",
Replace([MobileNumber], " ", ""), Replace([PhoneNumber], " ", "") AS Mobile
FROM tblCustomers;

Build a little, test a little.