Sql Query returning Blanks

Posted on 2011-10-06
Last Modified: 2012-05-12
could anybody tell me the query where in a column if it just blank what query would i need to return these values

is it
where column name = ' '

Question by:pepps11976
    LVL 25

    Accepted Solution

    Blank or null?

    If null then:

    where column is null

    if bkank/null then:

    where isnull(column, '') = ''


    Author Comment

    The column is blank this is my query so far  
    SELECT [ih_doc]
      FROM [DB_Opera_Copy].[dbo].[ihead]
      where ih_proform like '%PRO%'

    Open in new window

    and i want to add to the where "where ihsorder is blank"


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    If you have heard of RFC822 date formats, they can be quite a challenge in SQL Server. RFC822 is an Internet standard format for email message headers, including all dates within those headers. The RFC822 protocols are available in detail at:   ht…
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    761 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

    8 Experts available now in Live!

    Get 1:1 Help Now