Converting data types of fields

Question

Hi all

This is very simple but dont have alot of time at this point to figure out so would love if anybody can give me a post on this.

I want to do a simple select statement from a table that has one field that is of type 'xml'. So i cannot use the 'Like' function. How can i temporarily convert the xml type to for instance 'nVarChar' for me to use it like on that ?

Thank you