1 person found this helpful
Is your data source just the text " 85444200" ?
If so, does the following work?
select replace(CD_FISC, ' ', NULL)
If that doesn't help, can you describe your table definition along with the data the CD_FISC field contains?
I don't think this specific question belongs here in this forum. It is not a SQL Developer issue.
I resolve this with a TRIM of chr(160)!