I imported a database from Access to Sql Server Express, and one of the fields contains various Hex Unicode characters which is causing an error in my php file, so I would like to remove the characters from the field. The field type in sql server is nvarchar(max).
The values are:
& # x 9 ;
& # x A ;
& # x D ;
*inserted spaces between characters to display.
I haven't been able to find a way to remove these. The replace function doesn't work on it.
Thanks for any help!