I need to pull in a field that contains the Race of a person. Now for this report I just need to see If they are either part of a given Race or not. However, this field also has NULL values. SELECT ...

I want to replace the contents of a specific column with something else, regardless of what the original data in that column was. How can I do this with the replace() function in TSQL? Is tehre some ...