Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Null select

Null select

From: Kram <kram_at_biosys.net>
Date: 2000/05/12
Message-ID: <kATS4.4959$XO1.288625@bgtnsc06-news.ops.worldnet.att.net>#1/1

I am performing the select statement which includes formatting a credit card number with "-". However, the problem is if the record returns a null the "-" the statement still returns "---" is there a better way to perform this?

select crcname,
crcexp,
rpad(substr(crcardno,1,4) || '-' || substr(crcardno,5,4) || '-' || substr(crcardno,9,4) || '-' || substr(crcardno,13,4),25,' ') from crcard Received on Fri May 12 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US