Task:

List suppliers with their phone and fax numbers.
If they have no fax, return '****'.
Click here for details on Coalesce.
 
 32 Records
CompanyName Phone Fax
eli lilly (111) 444-2222 4
New Orleans Cajun Delights (100) 555-4822 ****
Grandma Kelly's Homestead (0)1-953530 (0)1-953555
Tokyo Traders (03) 8888-5011 (0)1-953555
Cooperativa de Quesos 'Las Cabras' (0)1-953530 (0)1-953555
Mayumi's (0)1-953530 (0)1-953555
Pavlova, Ltd. (0)1-953530 (0)1-953555
eli lilly (0)1-953530 (0)1-953555
Pakkoda Boys 031-987 65 43 031-987 65 91
Refrescos Americanas LTDA (0)1-953530 (0)1-953555
Heli Süßwaren GmbH & Co. KG (010) 9984510 ****
Plutzer Lebensmittelgroßmärkte AG (069) 992755 ****
Nord-Ost-Fisch Handelsgesellschaft mbH (04721) 8713 (04721) 8714
Formaggi Fortini s.r.l. (0544) 60323 (0544) 60603
Norske Meierier (0)1-953530 (0)1-953555
Bigfoot Breweries (503) 555-9931 ****
Svensk Sjöföda AB 08-123 45 67 ****
Aux joyeux ecclésiastiques (1) 03.83.00.68 (1) 03.83.00.62
New England Seafood Cannery (617) 555-3267 (617) 555-3389
Leka Trading 555-8787 ****
Lyngbysild 43844108 43844115
Zaanse Snoepfabriek (12345) 1212 (12345) 1210
Karkki Oy (953) 10956 ****
G'day, Mate (02) 555-5914 (02) 555-4873
Ma Maison (514) 555-9022 ****
Pasta Buttini s.r.l. (089) 6547665 (089) 6547667
Escargots Nouveaux 85.57.00.07 ****
Gai pâturage 38.76.98.06 38.76.98.58
Forêts d'érables (514) 555-2955 (514) 555-2921
eli lilly NULL ****
eli lilly 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