Mevotech
asked on
How can I convert a null column to a space when testing a integer column
Hello,
I have the following
SELECT MakeID_NAPA,
ISNULL(EngineID_NAPA, '') AS EngineID_NAPA,
FROM NAPA_Catalog
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.
Thank you
I have the following
SELECT MakeID_NAPA,
ISNULL(EngineID_NAPA, '') AS EngineID_NAPA,
FROM NAPA_Catalog
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.
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.