1
Answer

Converting data types of fields

Peter Ishere

Peter Ishere

16y
2.2k
1

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

Answers (1)