Link to home
Start Free TrialLog in
Avatar of Mevotech
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
ASKER CERTIFIED SOLUTION
Avatar of Mevotech
Mevotech

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial