select firstname, lastname, salutation, title, email, phone, phoneext, cellphone, orgtype, orgid, address1, address2, city, state, zipcode, OfficeAddrSame, staffMember, primaryOfficeId from tbl_fspro_members with (nolock) where fspro_userid = and ownerid = and fsl_tablecode = select companyname, address as address1, address2, city, state, zipcode, phone from tbl_opr_clientoperators with (nolock) where operatorid = and ownerid = and fsltablecode = select cdr_dstname as companyname, cdr_dstaddress1 as address1, cdr_dstaddress2 as address2, cdr_dstcity as city, cdr_dststate as state, cdr_dstzip as zipcode, cdr_dstPhone as phone from tbl_cdr_distributors with (nolock) where cdr_recordid = and ownerid = and fsl_tablecode = select broker_name as companyName from tblBrokers with (nolock) where broker_id = select broker_street_address as address1, broker_street_address2 as address2, broker_city as city, broker_state as state, broker_zip as zipcode, broker_areacode + '-' + broker_phone_number as phone from tblBrokerOffices with (nolock) where broker_office_id = select mfr_name as companyName, building_address as address1, building_address2 as address2, city, state, zip_code as zipcode, main_area_code + '-' + main_phone as phone from tblManufacturers with (nolock) where mfr_id = BEGIN:VCARD VERSION:3.0 N:#_lastname#;#_firstname#;;#_salutation# FN:#_firstname# #_lastname# ORG:#_companyName# TITLE:#_title# TEL;TYPE=WORK,VOICE:#_phone# TEL;TYPE=CELL:#_cellphone# ADR;TYPE=WORK,PREF:;;#_address1#;#_city#;#_state#;#_zipcode#; EMAIL:#_email# END:VCARD