Is that actually one character? You need to find the hex/decimal value of it in order to remove it. From UNIX you can try either an "od -h" to dump it in hex or use an actual hex editor to determine that. Lots of free ones out there.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Once you do find the decimal value, you can use the CHAR() function to represent it and then include that in something like Convert() to remove it by converting it to '', an empty string.
-craig
"You can never have too many knives" -- Logan Nine Fingers