I uploaded data using sql*loader. I think an inivisible special character is also imported. The length of the field in 1 more than the actual data. Can anyone tell me how I can trim the special character. TRIM function did not help.