SQL Function for XML search

Question

Hi,

   Can anyone tell me how to create SQL function to filter for attributes and elements from the given XML string .

 

Thanks

Sathish