Task:

List suppliers with their phone and fax numbers.
If they have no fax, return '****'.
Click here for details on Coalesce.
 
 36 Records
CompanyName Phone Fax
fff (111) 444-2222 4
fff 98765 490
fff (0)1-953530 (0)1-953555
fff (03) 8888-5011 (0)1-953555
fff 123-456 567-891
fff (0)1-953530 (0)1-953555
Pavlova, Ltd. (0)1-953530 (0)1-953555
fff (0)1-953530 (0)1-953555
Pakkoda Boys 031-987 65 43 031-987 65 91
fff (0)1-953530 (0)1-953555
Heli Süßwaren GmbH & Co. KG (010) 9984510 490
Plutzer Lebensmittelgroßmärkte AG (069) 992755 490
Nord-Ost-Fisch Handelsgesellschaft mbH (04721) 8713 (04721) 8714
Formaggi Fortini s.r.l. (0544) 60323 (0544) 60603
fff (0)1-953530 (0)1-953555
fff (503) 555-9931 490
Svensk Sjöföda AB 08-123 45 67 490
ARJUN (1) 03.83.00.68 (1) 03.83.00.62
fff (617) 555-3267 (617) 555-3389
Leka Trading 555-8787 490
Lyngbysild 43844108 43844115
Zaanse Snoepfabriek (12345) 1212 (12345) 1210
Karkki Oy (953) 10956 490
G'day, Mate (02) 555-5914 (02) 555-4873
Ma Maison (514) 555-9022 490
Pasta Buttini s.r.l. (089) 6547665 (089) 6547667
Escargots Nouveaux 85.57.00.07 490
Gai pâturage 38.76.98.06 38.76.98.58
Forêts d'érables (514) 555-2955 (514) 555-2921
fff (11) 1111-2222 490
fff NULL 490
Oxford Trading NULL ****
Oxford Trading NULL ****
Oxford Trading NULL ****
Oxford Trading NULL ****
Oxford Trading NULL ****
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas.      Vsn 1.3.0