I have the following
ISNULL(EngineID_NAPA, '') AS EngineID_NAPA,
where I check the EngineID_NAPA column for a null value.
Rather than replacing it with an integer I want to replace it with a space. The above statement shows 0 rather than space.
I tried casting but the check is done before the cast with a resulting '0'
Any help is appreciated.