How to enable REGEX for RC6 SQLite?

[Zvoni]

What Olaf is talking about RegEx doesn't seem to be just for sqlite-db. I guess he wanted to develop a generic RegEx engine that could replace JS.RegEx, which is exactly what many of us were expecting.

Might be, but wouldn't have anything to do with OP's question.
OP's question is about using the REGEXP-Operator/Function within SQL-Statements.
And in DB Browser's case i'd guess they compiled the extension and linked it statically into DB Browser itself (not into sqlite3.dll!), but "load" it into the engine on startup

[SearchingDataOnly]

Might be, but wouldn't have anything to do with OP's question.
OP's question is about using the REGEXP-Operator/Function within SQL-Statements.
And in DB Browser's case i'd guess they compiled the extension and linked it statically into DB Browser itself (not into sqlite3.dll!), but "load" it into the engine on startup

I seem to remember that RC6 could use VB6 functions as custom functions for sqlite.

[Zvoni]

I seem to remember that RC6 could use VB6 functions as custom functions for sqlite.

No idea, since i never used RC6, but wouldn't surprise me, since SQLite offers to use custom Functions --> https://www.sqlite.org/appfunc.html

Applications that use SQLite can define custom SQL functions that call back into application code to compute their results. The custom SQL function implementations can be embedded in the application code itself, or can be loadable extensions.

since SQLite is written in C, it's probable that the "off-the-shelf" dll's are compile with cdecl.
I seem to remember Olaf mentioning compiling SQLite with stdcall for RichClient, so AddressOf should work