Is Null Is.

List all suppliers that have no fax.

17 Records

Id	CompanyName	Phone	Fax
1	Exotic Liquids	(171) 555-2222	NULL
2	New Orleans Cajun Delights	(100) 555-4822	NULL
4	Tokyo Traders	(03) 3555-5011	NULL
5	Cooperativa de Quesos 'Las Cabras'	(98) 598 76 54	NULL
6	Mayumi's	(06) 431-7877	NULL
8	Specialty Biscuits, Ltd.	(161) 555-4448	NULL
10	Refrescos Americanas LTDA	(11) 555 4640	NULL
11	Heli Süßwaren GmbH & Co. KG	(010) 9984510	NULL
12	Plutzer Lebensmittelgroßmärkte AG	(069) 992755	NULL
15	Norske Meierier	(0)2-953010	NULL
16	Bigfoot Breweries	(503) 555-9931	NULL
17	Svensk Sjöföda AB	08-123 45 67	NULL
20	Leka Trading	555-8787	NULL
23	Karkki Oy	(953) 10956	NULL
25	Ma Maison	(514) 555-9022	NULL
27	Escargots Nouveaux	85.57.00.07	NULL
207	Broodjes Huis	31-1-382-8847	NULL

SQL Editor