render html in query

[mk761203]

Hi,

I can select memo field (configured as RichText) as rendered html:
select somehtmlfield from sometable
and have rendered html output:
"normal bold"
or select it as html string
select Cstr(somehtmlfield) from sometable
and get
"<div>normal <b>bold</b></div>

Is there any way to produce rendered html from string?
I would like to:
select SomeConvertingFunc("<div>something <b>bold</b></div>") from sometable
and have it rendered to "something bold".

 

[Pat Hartman]

No. If you want pretty-printing, use a report or a form. Select queries have one purpose and one purpose only and that is to retrieve data. They do not function as forms or reports and should never be exposed to users.