SQL Editor

SQL Iif Column Example

Task:

List suppliers with contact information. Include fax, but for those without fax use phone number instead.
Click here for details on IIF.
 
 29 Records
CompanyName Contact
Exotic Liquids Phone: (171) 555-2222
New Orleans Cajun Delights Phone: (100) 555-4822
Grandma Kelly's Homestead (313) 555-3349
Tokyo Traders Phone: (03) 3555-5011
Cooperativa de Quesos 'Las Cabras' Phone: (98) 598 76 54
Mayumi's Phone: (06) 431-7877
Pavlova, Ltd. (03) 444-6588
Specialty Biscuits, Ltd. Phone: (161) 555-4448
PB Knäckebröd AB 031-987 65 91
Refrescos Americanas LTDA Phone: (11) 555 4640
Heli Süßwaren GmbH & Co. KG Phone: (010) 9984510
Plutzer Lebensmittelgroßmärkte AG Phone: (069) 992755
Nord-Ost-Fisch Handelsgesellschaft mbH (04721) 8714
Formaggi Fortini s.r.l. (0544) 60603
Norske Meierier Phone: (0)2-953010
Bigfoot Breweries Phone: (503) 555-9931
Svensk Sjöföda AB Phone: 08-123 45 67
Aux joyeux ecclésiastiques (1) 03.83.00.62
New England Seafood Cannery (617) 555-3389
Leka Trading Phone: 555-8787
Lyngbysild 43844115
Zaanse Snoepfabriek (12345) 1210
Karkki Oy Phone: (953) 10956
G'day, Mate (02) 555-4873
Ma Maison Phone: (514) 555-9022
Pasta Buttini s.r.l. (089) 6547667
Escargots Nouveaux Phone: 85.57.00.07
Gai pâturage 38.76.98.58
Forêts d'érables (514) 555-2921
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.