asked on

Sql Query returning Blanks

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 = ' '

John

ASKER CERTIFIED SOLUTION

Lee

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

pepps11976

ASKER

The column is blank this is my query so far

SELECT [ih_doc]
      ,[ih_account]
      ,[ih_name]
      ,[ih_addr1]
      ,[ih_addr2]
      ,[ih_addr3]
      ,[ih_addr4]
      ,[ih_date]
      ,[ih_custref]
      ,[ih_desp]
      ,[ih_delad1]
      ,[ih_delad2]
      ,[ih_delad3]
      ,[ih_delad4]
      ,[ih_delad5]
      ,[ih_deladpc]
      ,[ih_ignore]
      ,[ih_sdis1]
      ,[ih_sdis2]
      ,[ih_odisc]
      ,[ih_narr1]
      ,[ih_narr2]
      ,[ih_prodate]
      ,[ih_quodate]
      ,[ih_credate]
      ,[ih_invdate]
      ,[ih_deldate]
      ,[ih_orddate]
      ,[ih_proform]
      ,[ih_quotat]
      ,[ih_invoice]
      ,[ih_credit]
      ,[ih_deliv]
      ,[ih_sorder]
      ,[ih_exvat]
      ,[ih_vat]
      ,[ih_sdays1]
      ,[ih_sdays2]
      ,[ih_samnt1]
      ,[ih_samnt2]
      ,[ih_overval]
      ,[ih_postacc]
      ,[ih_loc]
      ,[ih_docstat]
      ,[ih_memo]
      ,[ih_priorty]
      ,[ih_region]
      ,[ih_terrtry]
      ,[ih_route]
      ,[ih_due]
      ,[ih_revquo]
      ,[ih_revpro]
      ,[ih_revord]
      ,[ih_revdel]
      ,[ih_revinv]
      ,[ih_revcrn]
      ,[ih_prtstat]
      ,[ih_dcontr]
      ,[ih_scontr]
      ,[ih_econtr]
      ,[ih_fcurr]
      ,[ih_fcdec]
      ,[ih_fcval]
      ,[ih_fcrate]
      ,[ih_fcvat]
      ,[ih_addpc]
      ,[ih_delt]
      ,[ih_ntrn]
      ,[ih_mtrn]
      ,[ih_fcmult]
      ,[ih_edi]
      ,[ih_editx]
      ,[ih_edivn]
      ,[sq_user]
      ,[ih_raised]
      ,[ih_analsys]
      ,[ih_ebridge]
      ,[ih_ccard]
      ,[ih_expiry]
      ,[ih_cauth]
      ,[ih_cname]
      ,[ih_taxpoin]
      ,[ih_project]
      ,[ih_job]
      ,[ih_revchrg]
      ,[ih_validto]
      ,[ih_contid]
      ,[ih_ownerid]
      ,[ih_sprojid]
      ,[ih_status]
      ,[ih_prospec]
  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"

john