Dear Professional,

I am using following query but I would like to get all the records which has
address2 means NOT Null, how I can handle NULL in the following query.

select
AddressLine2
FROM Person.Address
for XML Path ('Customer'), ELEMENTS XSINIL

Thanks
Noor