set long 2000
select a.name, a.card.extract('/ACARD[EMAIL="roger12@yahoo.com"]/ADDRESS') as
rogeraddress
from addrbook a
where a.card.existsNode('/ACARD[EMAIL="roger12@yahoo.com"]') = 1;

