Hi.
On Tue, Aug 14, 2001 at 01:31:04PM -0700, [EMAIL PROTECTED] wrote:
> I am trying to do a nested if, but it appears to break my query...
> Here is a sample of what I am trying to, basically validating email
> addresses out of a db:
>
> select IF( (LENGTH( emailaddr ) <= 1 ||
> NOT LOCATE( "
I am trying to do a nested if, but it appears to break my query...
Here is a sample of what I am trying to, basically validating email
addresses out of a db:
select IF( (LENGTH( emailaddr ) <= 1 ||
NOT LOCATE( "\@",emailaddr ) ||
LOCATE( " ",emailaddr ),
(IF address.ts >= 2001081300,
