HI,

I have changed my code up so get only the specific record needed.

Here is what it look like now.

Once again I don't get any errors, but its like only the bottom IF works, because if ADR3 is null, it still selects the column even if its not in my if statement.

DECLARE @ADR1 VARCHAR(100), @ADR2 VARCHAR(100), @ADR3 VARCHAR(100), @POSTAL_CODE VARCHAR(100), @CURRENT_ONE SMALLINT

SET @ADR1 = 'P O Box 2258'

SET @ADR2 = 'Johannesburg'

SET @ADR3 = 'null'

SET @POSTAL_CODE = '2000'

SET @CURRENT_ONE = '1'

IF @ADR3 IS NULL

SELECT ADR1, ADR2, POSTAL_CODE

FROM PAT_NAMES_ADDRESS

WHERE CURRENT_ONE = RTRIM(@CURRENT_ONE)

AND ADR1 = RTRIM(@ADR1)

AND ADR2 = RTRIM(@ADR2)

AND ADR3 = RTRIM(@ADR3)

AND POSTAL_CODE = RTRIM(@POSTAL_CODE)

ELSE IF @ADR3 IS NOT NULL

SELECT ADR1, ADR2, ADR3, POSTAL_CODE

FROM PAT_NAMES_ADDRESS

WHERE CURRENT_ONE = RTRIM(@CURRENT_ONE)

AND ADR1 = RTRIM(@ADR1)

AND ADR2 = RTRIM(@ADR2)

AND ADR3 = RTRIM(@ADR3)

AND POSTAL_CODE = RTRIM(@POSTAL_CODE)