Is it possible to replace the ''+++++++++++++++++++++++++++++" symbols from a field to 0 ?
SELECT LRLREF, LRVALR, LRCLIR, LRDTAA, LRDTMM, LRDTJJ, LRNTMC,
REPLACE(LRNTMC,'+++++++++++++++++++++++++++++',0) X
FROM LIB1.TABLE1 WHERE LRLREF = '1'
The result from the query:
I appreciate any help.
SELECT LRLREF, LRVALR, LRCLIR, LRDTAA, LRDTMM, LRDTJJ, LRNTMC,
REPLACE(LRNTMC,'+++++++++++++++++++++++++++++',0) X
FROM LIB1.TABLE1 WHERE LRLREF = '1'
The result from the query:
I appreciate any help.
Comment