Remove Questoin Mark '?' character from LiveReport

Vijhay Devarajan

Could someone tell me how the '?' character can be efficiently removed from a LiveReport.

Thanks

Vijhay Devarajan

Find more posts tagged with

Comments

Narasimha_Rao

Hi Vijhay,

This is the sample query using CASE to remove "question mark"

SELECT k.ID AS GROUPID ,k.NAME AS GROUPNAME ,k.TYPE AS GROUPTYPE ,c.ID AS USERID ,

CASE WHEN c.LASTNAME IS NULL THEN ' ' ELSE c.LASTNAME END AS LASTNAME

FROM kuaf k ,kuaf c, kuafchildren kc WHERE c.ID = k.ID AND k.TYPE = 1 AND k.ID = kc.ID

Thanks and Regards,
Narsi
Supai Systems,
Bangalore, India.
e-mail : narsi@supaisystems.com
website: www.supaisystems.com

On Thu, Feb 9, 2012 at 7:37 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Remove Questoin Mark '?' character from LiveReport Posted byvijhay.devarajan@sce.com (Devarajan, Vijhay)On 02-08-2012 21:00

Hi Could someone tell me how the '?' character can be efficiently removed from a LiveReport. Thanks Vijhay Devarajan
[To post a comment, use the normal reply function]
Forum: Content Server LiveReports Forum
Content Server: Knowledge Center