Thanks MM!!..

This works fine... But only problem is ,xml is just a column in my table.

Can you please tel me how can a i create a function for this , so that i can write as SELECT UDF (@EValue) FROM tablename WHERE fieldName = @Paramaeter