Robert Simpson <[EMAIL PROTECTED]>
wrote:
-----Original Message-----
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Not like this, but you can create a function and use it this way:
SELECT * FROM Table WHERE MYFUNCTION(Name, param)
Actually with a userdef function,
SELECT * FROM Table WHERE MYFUNCTION(Name, param)
... is identical to:
SELECT * FROM Table WHERE param MYFUNCTION Name
Are you sure? This works:
select * from test where ifnull(field,1);
These produce syntax error
select * from test where field ifnull 1;
select * from test where 1 ifnull field;
I've just tried with a user-defined function - same result.
Igor Tandetnik
