ok lets see if this is what you're after...

IF (EXISTS(

SELECT TOP 1 1

FROM PAT_NAMES_ADDRESS

WHERE NAME_ID = @NAMEID

AND ADR2 IS NULL

AND ADR3 IS NULL

))

BEGIN

SELECT ADR1,

POSTAL_CODE,

(STATE_NAME) AS COUNTRY

FROM PAT_NAMES_ADDRESS AS P

INNER JOIN STATE_NAME AS S ON P.STATE_ID = S.STATE_ID

WHERE P.NAME_ID = @NAMEID

AND P.CURRENT_ONE = '1'

AND P.LANGUAGE_ID = '3'

END