How can I convert a null column to a space when testing a integer column

Posted on 2012-08-15
Last Modified: 2013-11-19

I have the following

              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
Question by:Mevotech
    1 Comment

    Accepted Solution

    Answered my own question by writing it out, just reversed the logic


    and works.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.
    The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now