Hello all,
I was trying to modify an exsisting program the does a simple data dump, but I wanted to manipulate one of the feilds during the dump. The feild is an ID feild and I would like to change the format to appear as XXXXX9999. This following line works well in SQL but not in 4GL and direction would be appreicated.
replace(idno, substr(idno,1,5), 'XXXXX')
I was trying to modify an exsisting program the does a simple data dump, but I wanted to manipulate one of the feilds during the dump. The feild is an ID feild and I would like to change the format to appear as XXXXX9999. This following line works well in SQL but not in 4GL and direction would be appreicated.
replace(idno, substr(idno,1,5), 'XXXXX')