filter with <NULL>

Posted on 2005-04-20
Last Modified: 2010-04-23
How can I this
dvContratoMaquila.RowFilter = "FechaFinal='<NULL>'"
I need filter all the rows with this field NULL.


Question by:miguelmam
    LVL 14

    Accepted Solution

    if it's from SQL database:

    dvContratoMaquila.RowFilter = "FechaFinal Is Null"
    LVL 14

    Expert Comment

    That worked for me.

    Other suggestions are:
     -- Syncfusion
     ' for a numeric null in FechaFinal
         dvContratoMaquila.RowFilter = "IsNull(FechaFinal, 0) = 0"

     -- Microsoft
    To return only those columns with null values, use the following expression:
         "Isnull(Col1,'Null Column') = 'Null Column'"

     -- Some discussion

    Featured Post

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
    Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    746 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

    16 Experts available now in Live!

    Get 1:1 Help Now