Replace NULL characters in string???

[freavis]

I wasn't sure where to post this but I thought I would start here.

My issue.
I have a column in a table that can contain up to 7000 characters. Some the rows that resides in this column has a null value as the very last character. How can I remove that null character without manually doing it?

 

[ptheriault]

look up ISNULL(), COALECE() or REPLACE() in BOL.

- Paul
- If at first you don't succeed, find out if the loser gets anything.