Select NULL

Posted on 2009-12-22
Last Modified: 2012-05-08
Hey folks,
  I have a field in my table that is integer

There is some data that when it gets imported has no data for this field.

When I do a Select * from customer I see "NULL" in the field.

However I can't select on that example...none of the select statements below work...
Little help?

Select * from customer where oldid = NULL
Select * from customer where oldid = 'NULL'
Select * from customer where LEN(oldid) < 1
Question by:lrbrister
    LVL 2

    Accepted Solution

    select * from customer where oldid is null
    LVL 15

    Expert Comment

    if you dont need to display null values then u can give as

    Select * from customer where oldid is not NULL


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    779 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

    10 Experts available now in Live!

    Get 1:1 Help Now