Removing Question marks from Auto LiveReports

Message from Eidson Matthew W Contr AFFTC/ITASC via eLinkGuru's,This might be a dumb question but is there a slick way I can remove thequestion marks from a LiveReport that get returned from a null value?Just curious...Thanks,_______________________________________________________________________Matt EidsonAFFTC/ITASCLivelink Integrator/Developer - Network Systems AnalystTybrin CorporationOffice: 661-275-3704Mobile: 661-810-6091Nextel DC: 122*11*6004We can walk our road togetherIf our goals are all the sameWe can run alone and freeIf we pursue a different aimLet the truth of love be lightedLet the love of truth shine clearSensibilityArmed with sense and libertyWith the Heart and Mind unitedIn a single perfect sphereBand: Rush - Album: Hemispheres - Song: Cygnus X-1 Book II: Hemispheres -Year: 1978

Find more posts tagged with

Comments

eLink User

Message from Olson, Leonard <<A HREF="mailto:len.olson@rgsinc.com">len.olson@rgsinc.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

The Oracle DECODE statement might be worth a try. To eliminate null values you would include this in your decode statement.

DECODE (null, ' ')

MS SQL server uses a different statement to accomplish the same thing.

-----Original Message-----
From: eLink Discussion: Livelink LiveReports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, March 06, 2003 1:28 PM
To: eLink Recipient
Subject: Removing Question marks from Auto LiveReports

Removing Question marks from Auto LiveReports Posted by eLink on 03/06/2003 01:28 PM

Message from Eidson Matthew W Contr AFFTC/ITASC <Matthew.Eidson@edwards.af.mil> via eLink

Guru's,

This might be a dumb question but is there a slick way I can remove the
question marks from a LiveReport that get returned from a null value?

Just curious...

Thanks,

_______________________________________________________________________
Matt Eidson
AFFTC/ITASC
Livelink Integrator/Developer - Network Systems Analyst
Tybrin Corporation
Office: 661-275-3704
Mobile: 661-810-6091
Nextel DC: 122*11*6004

We can walk our road together
If our goals are all the same
We can run alone and free
If we pursue a different aim

Let the truth of love be lighted
Let the love of truth shine clear
Sensibility
Armed with sense and liberty
With the Heart and Mind united
In a single perfect sphere

Band: Rush - Album: Hemispheres - Song: Cygnus X-1 Book II: Hemispheres -
Year: 1978

Kate Bott

If it's Oracle, use the NVL function e.g. select NVL(column_name, ' ')