SELECT dbo.fx_Jurisdiction1(country,stateorprovince) as 'jurisdiction',vmcontactid as contactid,companyname,address1,address2,city,stateorprovince,country, mainphone,mainfax,mainemail, companyid,companytype,ziporpostalzone, vmfirst as firstname,vmlast as lastname,vmmiddle as middlename,vmemail as email,vmphone as directdial1, CASE CompanyId WHEN 10014 THEN 'D.C.' ELSE stateorprovince END AS State FROM wsgCompanies left join VMainContacts on vmcompanyid=companyid where typelisting in ('M') and country<>'demoland' and directory=1 and wsgcompanies.companyid not in (7358,76,9771,8296) and companytype not in ('Insurances') and (wsgcompanies.firmid is null or wsgcompanies.firmid<>7358) and len(address1)>0 and (region=3)

GLOBAL MEMBER DIRECTORY
PRINT		|	SORT BY FIRM/COMPANY

REGIONAL MEMBER DIRECTORY

AFRICA | ASIA | CARIBBEAN | CENTRAL AMERICA | EUROPE | MIDDLE EAST | NORTH AMERICA | SOUTH AMERICA

WEBSTER LP|Anguilla    Industry: Legal Services   Contact: Pam J. Webster   Email: send an Email   Address: Victoria House   P.O. Box 58   AI-2640 The Valley Anguilla   Phone: +264 497 2060   Fax: +264 461 3096				GrahamThompson|Bahamas    Industry: Legal Services   Contact: Judith A. Whitehead   Email: send an Email   Address: P.O. Box N-272   00000 Nassau, New Providence Bahamas   Phone: +242 322 4130   Fax: +242 328 1069
Clarke Gittens Farmer|Barbados    Industry: Legal Services   Contact: Ramon O. Alleyne   Email: send an Email   Address: Parker House   Wildey Business Park, Wildey Rd.   BB14006 St. Michael Barbados   Phone: +246 436 6287   Fax: +246 436 9812				O'Neal Webster|British Virgin Islands    Industry: Legal Services   Contact: Vanessa King   Email: send an Email   Address: Commerce House 2nd Floor, 181 Main Street   Road Town   . Tortola British Virgin Islands   Phone: +284 393 5800   Fax: +284 393 5808
Carey Olsen|Cayman Islands    Industry: Legal Services   Address: PO Box 10008, Willow House, Cricket Square   KY1-1001 Grand Cayman Cayman Islands   Phone: +1 345 749 2000   Fax: +1 345 749 2100				Pellerano & Herrera|Dominican Republic    Industry: Legal Services   Contact: Ricardo Pellerano   Email: send an Email   Address: 1019 Abraham Lincoln Ave.   Edificio Federico Pag�s Mor�, 5th floor   23100 Santo Domingo Dominican Republic   Phone: +809 541 5200   Fax: +809 567 0773
Floissac Du Boulay & Thomas|St. Lucia    Industry: Legal Services   Contact: Geoffrey DuBoulay   Email: send an Email   Address: Quadrant Row,9-11 Brazil Street   00000 Castries St. Lucia   Phone: 7584523250   Fax: 7584531496				Misick and Stanbrook|Turks & Caicos    Industry: Legal Services   Contact: Owen Foley   Email: send an Email   Address: Richmond House   Leeward Highway   Providenciales Turks & Caicos   Phone: +649 946 4732   Fax: +649 946 4734