Just below that I set the value.

SET @ADR3 = (SELECT ADR3

FROM PAT_NAMES_ADDRESS

WHERE ADR1 = @ADDRESS)

SET @ADDRESS = 'M & B Pumps Division'