select * from tbl_OPR_Operators
where oprSegment = 3
SELECT s.stateID, s.State, s.stateFull, c.countryId, c.country
FROM tbl_UT_States s
INNER JOIN tbl_UT_Countries c
ON s.countryId = c.countryId
WHERE c.countryid = 27
AND s.stateFull like
SELECT s.stateID, s.State, s.stateFull, c.countryId, c.country
FROM tbl_UT_States s
INNER JOIN tbl_UT_Countries c
ON s.countryId = c.countryId
WHERE c.countryid = 27
AND s.stateFull like
#_operatorId#
#_address1#
#_address2#
#_city#
#_state#
#_zipCode#
update tbl_OPR_Operators
set address = ,
address2 = ,
city = ,
state = ,
zipcode =
where opr_id =