Hi Olaf, I think it should be: Select Left$(TheField, Instr(TheField,']')) From Tbl
Have tested you new dll's and all working fine as usual. Bart On 9/11/12, Olaf Schmidt <s...@online.de> wrote: > Am 10.09.2012 17:17, schrieb Bart Smissaert: >> Ah, OK. I have a feeling that needs to be done either in your >> application code or with a user defined SQLite function. >> Somebody may prove me wrong. > > Hi Bart, > > since I know you're using my COM-Wrapper, a larger set > of Functions (in "VBA-Style", similar to the JET-Engine) are > already built-in there (including Instr, Left$, Right$, Mid$, > DateDiff, DatePart, ... etc.). > > For example Sébastiens requirement could be handled this way: > > Select Mid$(TheField, Instr(TheField,'[') From Tbl > > Olaf > > BTW, a new version including newest SQLite 3.7.14 is out now > since yesterday: www.datenhaus.de/Downloads/vbRC4BaseDlls.zip > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
