Peter Ishere

Peter Ishere

  • NA
  • 40
  • 0

Converting data types of fields

Jun 19 2008 9:41 AM

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)