I am loading data from a table and would like to remove the two last characters of the field PRV_CODE. (#0)
These characters is allways in the end of the value, but the length of the PRV_CODE can vary.
if its '#0' always. You can use the Replace function to replace the '#0' with a '' (blank).
you can use
Use below in your script instead of PRV_CODE
Replace(PRV_CODE,'#0','') as PRV_CODE
Use Purge Char fuction
Thanks for all answers.The code worked fine :-)
Retrieving data ...