Re: Blank field in column

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 07/01/04 

Date: Thu, 1 Jul 2004 08:53:26 +0530

Hi,

Use the below query to delete invoice number with NULLS, 0's and Blanks:-

DELETE FROM ORDER_HEADER
WHERE (INVOICE_NUMBER IS NULL) OR (INVOICE_NUMBER = '0')
OR (DATALENGTH(LTRIM(RTRIM(INVOICE_NUMBER)))=0) 

--
Thanks
Hari
MCDBA
"Bill" <anonymous@discussions.microsoft.com> wrote in message
news:238c201c45ef6$c0af5ba0$a601280a@phx.gbl...
> I am using the following query:
>
> DELETE FROM ORDER_HEADER
> WHERE (INVOICE_NUMBER IS NULL) OR (INVOICE_NUMBER = '0')
>
> This works fine but doesn't remove the records where the
> INVOICE_NUMBER field is blank.
>
> Is there a way to identify a blank or empty field?

Relevant Pages

  • Re: MSAccess Table: subtract 2 rows (get time difference [minutes] be.
    ... If I may ask a related question Douglas, is it legit to then write that ... computed value back to an empty field in ... > fourth computed field to the query. ... I am NOT a programmer!!! ...
    (microsoft.public.access.gettingstarted)
  • Re: Data Matching
    ... following expression in an empty field: ... Now create a third query that includes both the first two queries. ... >> records in both tables that share the common field. ...
    (microsoft.public.access.queries)
  • Re: week
    ... In your query, put this expression in an empty field: ... Your Resource For Help With Access, Excel And Word Applications ... I have an access 2000 table named payments and would like to select ...
    (microsoft.public.access.queries)
  • Re: Digit selection for a new code
    ... Put the following in an empty field in your query: ... Your Resource For Help With Access, Excel And Word Applications ... > In a query, I have a field called MEMBERSHIPDATE with the format MM/DD> /YYYY. ...
    (microsoft.public.access.queries)
  • Re: Field not empty
    ... If it Is Not Null then it should have data in it, so an empty field will not ... If you want it to show up you need a "date of leaving" in it. ... > If I take a query and as for all records where that field Is Not Null ... > Robin Chapple ...
    (microsoft.public.access.gettingstarted)