What is the Null Character literal in TSQL?
- by David in Dakota
I am wondering what the literal for a Null character (e.g. '\0') is in TSQL.
Note: not a NULL field value, but the null character (see link).
I have a column with a mix of typical and a null character. I'm trying to replace the null character with a different value. I would have thought that the following would work but it is unsuccessfull:
select REPLACE(field_with_nullchar, char(0), ',') from FOO where BAR = 20