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 removed it.

I know that a cursor would be incredibly less inefficient but i am not sure what you mean about "one row". This is going to run across a table. Can't i step through each record and parse through the text (not sure what that would look like yet).

So how would I apply this code across the dataset (a join of two tables, Actions and Users, joined on Actions.UserID = Users.UserID?)

I assume that i would replace the SELECT '' that contains the sample text with a SELECT TextHTML FROM Actions? And then maybe SELECT FirstName FROM Users under the Operators(username) AS? But then what ties the datasets together to find out of the name associated to the UserID on the Actions record matches the name found in the brackets?

Argh.

PK