Usually when we do the sqlload the '|' appends to the end of the string. This '|' is knows as Chr(13) and can be removed once the sqlload is done using the following update statement:
Update [table_name]
set [column_name] = trim(chr(13) from [column_name])
No comments:
Post a Comment