Yes. I needed it to work as an operator in the form: FIELD REGEXP ".*", not regexp(FIELD,".*")
-----Original Message----- From: Jay Sprenkle [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 10, 2005 10:32 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] REGEXP as an operator On 5/10/05, John Buck <[EMAIL PROTECTED]> wrote: > Greetings, > > I am new to this list and the Sqlight project. > > I ran across it while doing research on locating an alternative to the Mysql > Embedded engine. Sqlite seems like it will do the trick with a few tweaks. > I just wanted to share one of those tweaks for comment. > > One problem I ran into was I had used REGEXP as an operator throughout > hundreds of lines of SQL. > > So with a little work I added REGEXP as an operator to Sqlite 3.21. > You can download the change for a limited time from > municipal-software.com/Sqlite3.21REGEXP.zip I guess you added it to the code directly and didn't create your own function?