> -----Original Message----- > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 27, 2006 7:48 AM > To: SQLite > Subject: [sqlite] Re: User function in WHERE clause > > Stan <[EMAIL PROTECTED]> wrote: > > is there a way to create user function similar to LIKE? > > I'd like to use my function in clause WHERE. E.g. this selection: > > SELECT * FROM Table WHERE Name MYFUNCTION param > > Param is integer. > > 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 Robert
