RE: [sqlite] REGEXP as an operator

2005-05-11 Thread John Buck
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

Re: [sqlite] REGEXP as an operator

2005-05-10 Thread Jay Sprenkle
> 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

[sqlite] REGEXP as an operator

2005-05-10 Thread John Buck
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 use this with both windows (Visual Studio) and linux (GCC