something <> ''
...?
~Todd
At 05:19 PM 1/7/2003 +0100, you wrote:
>Dwayne Cole wrote:
>
> >>try != (not equal):
> >>
> >>
> >
> >I tried this to no avail. <> 'dwayne' works and so does != 'dwayne' but
> != '' does not. I wonder if this is a Q-of-Q bug.
> >
> >
>not email is null
>
>?
>
>Jesse
Dwayne Cole wrote:
>>try != (not equal):
>>
>>
>
>I tried this to no avail. <> 'dwayne' works and so does != 'dwayne' but != '' does
>not. I wonder if this is a Q-of-Q bug.
>
>
not email is null
?
Jesse
~|
Archives: htt
>try != (not equal):
I tried this to no avail. <> 'dwayne' works and so does != 'dwayne' but != '' does
not. I wonder if this is a Q-of-Q bug.
==
>>
>> SELECT PERSON,
>> EMAIL
>>
>> FROM qry_PERSON
>>
>> WHERE EMAIL <> ''
>>
>>
>> This query w
l Message -
From: "Dwayne Cole" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 06, 2003 11:39 PM
Subject: Query-of-Query All but [empty string]
>
> SELECT PERSON,
> EMAIL
>
> FROM qry_PERSON
>
> W
SELECT PERSON,
EMAIL
FROM qry_PERSON
WHERE EMAIL <> ''
This query wont work. When I query the database directy the WHERE clause in the SQL
statement works fine but when I query a query object it ignors the WHERE clause.
How do I reference [empty string] cells in query o
5 matches
Mail list logo