Hi John,

I di what you said: SET @ADR3 = (SELECT ADR3

FROM PAT_NAMES_ADDRESS

WHERE ADR1 = @ADDRESS)

SELECT @ADR3

The value it returns is null.

But it doesn't make sense because when I check it outside of an if statement:

SELECT ADR1, ADR2,adr3, POSTAL_CODE

FROM pat_names_address

WHERE ADR3 is not null

AND ADR1 = 'M & B Pumps Division'

It does return a value.

Why is that?