Thank you for the simple query.

Yes,the table alias column has more than 1 value.

I would like to compare address column with alias column.

If address column is equal alias column then alias column is as NULL if not than it leave the current alias value.