• ELSE IF @status = 'Divorced'

    ......

    Instead of this:

    ELSE @status = 'Divorced'

    thank you my friend 😉