Blank field in column
From: Bill (anonymous_at_discussions.microsoft.com)
Date: 06/30/04
- Next message: Hari: "Re: Blank field in column"
- Previous message: Will: "Need some help A.S.A.P."
- Next in thread: Hari: "Re: Blank field in column"
- Reply: Hari: "Re: Blank field in column"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 30 Jun 2004 16:05:36 -0700
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?
- Next message: Hari: "Re: Blank field in column"
- Previous message: Will: "Need some help A.S.A.P."
- Next in thread: Hari: "Re: Blank field in column"
- Reply: Hari: "Re: Blank field in column"
- Messages sorted by: [ date ] [ thread ]