Ok, so this is pretty cool. I wish i knew how it worked.

It looks like the sample code had an extra ;WITH Actions (message) AS ( so I...

I don't get what "operator" is in these examples. I would also prefer to not use the splitter function.

I am to the point where i may have to rely on...

OK, i put an underscore inside every HTML tag. This is what the field looks like. I need to find the first customer entry, including the HTML tags at...

Ok I will try that. I am curious what formatting is lost in the conversion.

I have tried a bunch of those tags and they all still process the HTML tags in my example.

Oh my gosh how do i post this text field contents without it running the HTML tags???

Oh hell, i see the problem. I posted the raw data in my first post, but it acted on the HTML tags. I did not even notice that.

I cant...

Ok, I admit, I have no idea what this is doing.

I tweaked the code to what i thought would work (note that i added the WHERE ID = 6831908 just...

Great question. In most cases, the customer will be first and last name. But since this is not guaranteed, yes, there will be situations where the wrong line...

opc.three I like your idea, if I can figure out how to cast the field as unicode within the query.

Yeah, that's the issue...finding the DB2 syntax to strip out the crud. More Googling.

A user on another forum suggested that I dump the error output into a text file.

I did this and I believe it has shed some light on the problem....

When i try that it says that the field cannot convert between unicode and non unicode string data types.

Do I make that change to DT_WSTR on the field in the External Columns or Output Columns?

The original query was actually written in 2005 where the DATE data type did not exist.