I am working on a project in which bulk data is being uploaded from a Excel file in my SQL table, this data include mostly the space characters which I am not able to replace by Ltrim Rtrim. I search for this special character Ascii, Sometimes it shows it ascii 160 sometimes 9. I also tried with Replace function but replaces the spaces between the string which is not my requirement.
Can any one help me out of this