Problem:

List all suppliers without a fax number. Return records where Fax is NULL and also where Fax = '' (empty string).
Click here for details on NULLIF.
 
 16 Records
CompanyName City Country Phone Fax
Exotic Liquids London UK (171) 555-2222 NULL
New Orleans Cajun Delights New Orleans USA (100) 555-4822 NULL
Tokyo Traders Tokyo Japan (03) 3555-5011 NULL
Cooperativa de Quesos 'Las Cabras' Oviedo Spain (98) 598 76 54 NULL
Mayumi's Osaka Japan (06) 431-7877 NULL
Specialty Biscuits, Ltd. Manchester UK (161) 555-4448 NULL
Refrescos Americanas LTDA Sao Paulo Brazil (11) 555 4640 NULL
Heli Süßwaren GmbH & Co. KG Berlin Germany (010) 9984510 NULL
Plutzer Lebensmittelgroßmärkte AG Frankfurt Germany (069) 992755 NULL
Norske Meierier Sandvika Norway (0)2-953010 NULL
Bigfoot Breweries Bend USA (503) 555-9931 NULL
Svensk Sjöföda AB Stockholm Sweden 08-123 45 67 NULL
Leka Trading Singapore Singapore 555-8787 NULL
Karkki Oy Lappeenranta Finland (953) 10956 NULL
Ma Maison Montréal Canada (514) 555-9022 NULL
Escargots Nouveaux Montceau France 85.57.00.07 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