That worked great as well.
Want to say a special thanks for your help on this thread. I was looking at about 8 hours of work ripping out an existing functionality that put a text representation into a memo field and converting to using a table. By being able to use the XML in the same memo field, it has only taken me about 2 hours to get it to that same place.
>I would check
>
>LEFT(Xml,5) = "<?xml"
>
>It doesn't guarantied that it's valid XML but I doubt that you have memos that starts with that and are not valid XML.
>
>
>>That worked great! Is there a way for me to determine if the contents are actually valid XML? It's possible that during a transition period some of the memo fields will not have XML in them and I don't want to try and create a cursor from bad data.
>>