Can we make fulltext search on a table which is created using openxml()
from xml ???

for eg

tblEmployee contains - name, address

where

address is in the format of

<Addresses>
<Address type = "res" state = "xxx" city = "xxxxx" pincode = "xxxxx" />
<Address type = "off" state = "xxx" city = "xxxxx" pincode = "xxxxx" />
<Addresses>

i want to make a full text search with state field