Thursday, October 16, 2008

Chr(13) appended to column values while performing sqlload

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: