Hmm. How about:
SELECT *
FROM tablename
WHERE LENGTH(somecolumn) > 0 AND ISNULL(othercolumn) != 1
Michael
On Mon, 29 Apr 2002, Andrew Kuebler wrote:
> I want to query records that do not contain empty strings and null
> values through a SELECT statement.
>
> IS NOT NULL works for the
>I want to query records that do not contain empty strings and null
>values through a SELECT statement.
>
>IS NOT NULL works for the nulls, but how I select non-empty strings
>("")? I tried everything I can think of and even some non-published
>statements like name IS NOT '' . I just can't fi
Have you tried "... WHERE columnname=''; "??
Gurhan
-Original Message-
From: Andrew Kuebler [mailto:[EMAIL PROTECTED]]
Sent: Monday, April 29, 2002 12:55 PM
To: [EMAIL PROTECTED]
Subject: Not secting empty strings
I want to query records that do not contain em
I want to query records that do not contain empty strings and null
values through a SELECT statement.
IS NOT NULL works for the nulls, but how I select non-empty strings
("")? I tried everything I can think of and even some non-published
statements like name IS NOT '' . I just can't figure i
I want to query records that do not contain empty strings and null
values through a SELECT statement.
IS NOT NULL works for the nulls, but how I select non-empty strings
("")? I tried everything I can think of and even some non-published
statements like name IS NOT '' . I just can't figure i