SELECT bill_name, IsNull(NullIf(company, ''), bill_name) AS company, bill_addr1, bill_addr2, bill_city, bill_zip, bill_phone, comp_fax, comp_desc, comp_url FROM eframe_shopper WHERE ((comp_type=3) AND (show_dir=1) AND (bill_state='NJ')) ORDER BY IsNull(NullIf(company, ''), bill_name) ASCģ81 Digaetano Terrace, West Orange, NJ, 07052, Phone: 97, Fax:Ĥ5 S Maple Street, Fords, NJ, 08863, Phone: 1-73, Fax:ģ196 Kennedy Blvd., Kennedy Center (2nd Floor), Union City, NJ, 07087, Phone: 1-20, Fax:ġ34 Prospect Plains Road, Monroe Twp., NJ, 08831, Phone: 1-60, Fax: 60ġ110 New Road, Absecon, NJ, 08201, Phone: 1-60, Fax:Ģ90 Mounts Corner Drive, Freehold, NJ, 07728, Phone: 1-73, Fax: 73ħ98 Route 45, Pilesgrove, NJ, 08098, Phone: 1-85, Fax:
0 kommentar(er)
