I'm trying to use Advanced Datagrid, and SQLGridSelectedView to retrieve data from existing modules and display it.  The problem that I'm having is that in modules such as Events and text/html, the data is htmlencoded on the way in to the database, and when I retrieve it, I can't seem to find a way of unencoding it so that the formatting is done properly.

Anyone have any hints as to how I can resolve this?

Many thanks

Barry

OK tried this, so my select snippet is:

 Select EventName, 'server.htmldecode(' + EventDesc + ')', RepeatType... etc

and I get this error:

Invalid operator for data type. Operator equals add, type equals ntext.

so it would appear that I can't do concatenation with EventDesc as it's a text field.

I can however, if I use substring eg:

 Select EventName, 'server.htmldecode(' + substring(eventdesc,1,1024) + ')', RepeatType... etc

but then I just get server.htmldecode(<p>... written out to the browser.