Sql query replacing special character
I need an Sql server 2016 Sql query for following
There is some weird character in the data I have . It looks like whitespace in excel . But it is found the uncode for it is u00a0
I have undelined a repetition of the character above ( Not sure it comes correct though)
I was looking a way by which this character can be removed in the result of query
There is some weird character in the data I have . It looks like whitespace in excel . But it is found the uncode for it is u00a0
I have undelined a repetition of the character above ( Not sure it comes correct though)
I was looking a way by which this character can be removed in the result of query
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
lcohan
Before replacing it - did you considered the fact that after char is replaced the whole string purpose/meaning may be altered as that char you refer to looks like 'NO-BREAK SPACE' (U+00A0) which is a "forced" char "In word processing and digital typesetting, a non-breaking space, , also called no-break space, non-breakable space (NBSP), required space,[1] hard space, or fixed space,[note 1] is a space character that prevents an automatic line break at its position. In some formats, including HTML, it also prevents consecutive whitespace characters from collapsing into a single space."