xbox360dp
asked on
TO_CHAR - Tab in column when converting varchar2 field to currency.
Gurus,
I'm noticing a tab in the column when converting a varchar2 field to currency. I'm using the TO_CHAR function to do this.
Select Distinct to_char(Prsprsc/100/2,0'99 9.99')
From Kat,Kav,Kvt,pro,art,aez,pr s
Where
Kavkatkeyi = Katkeyi And
Artkeyi = Aezartkeyi And
Prokeyi = Aezprokeyi And
Artkavkeyi = Kavkeyi And
Artkeyi = Prsartkeyi And
prskavkeyi = artkavkeyi and
prokatkeyi = katkeyi and
Kvtkeyi = Kavkvtkeyi And
Katpf7c = 'Jewel' And
(Artvf5c Like '%Deli%' Or Artvf10c Like '%DELI%') And
Prsvf15c = 'lb.' And
Kvtbezc In ('CHGO-78CA','DKLB-78CC',' BNRM-78CE' )
and artkeyi = 163245;
Returns
prsprsc = ' 5.00'
Should Return
prsprsc = '5.00'
Seems simple enough but I'm obviously doing something wrong.
Help?
I'm noticing a tab in the column when converting a varchar2 field to currency. I'm using the TO_CHAR function to do this.
Select Distinct to_char(Prsprsc/100/2,0'99
From Kat,Kav,Kvt,pro,art,aez,pr
Where
Kavkatkeyi = Katkeyi And
Artkeyi = Aezartkeyi And
Prokeyi = Aezprokeyi And
Artkavkeyi = Kavkeyi And
Artkeyi = Prsartkeyi And
prskavkeyi = artkavkeyi and
prokatkeyi = katkeyi and
Kvtkeyi = Kavkvtkeyi And
Katpf7c = 'Jewel' And
(Artvf5c Like '%Deli%' Or Artvf10c Like '%DELI%') And
Prsvf15c = 'lb.' And
Kvtbezc In ('CHGO-78CA','DKLB-78CC','
and artkeyi = 163245;
Returns
prsprsc = ' 5.00'
Should Return
prsprsc = '5.00'
Seems simple enough but I'm obviously doing something wrong.
Help?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER