I think you just need to implement an INSTR(x,y,z) where X is the input string.
Y is the search string, and z is the search starting location. Typically
negative numbers indicate the end of the string to search backwards.
So
Substr(t1.col, 0, instr(t1.col, '.', -1) ) || '(' t2.col ||')' ||
substr(t1.col, instr(t1.col,'.',-1) ) from t1, t2 where t1.id = t2.id
Should get you pretty close.
See load_extension to get an idea on how to build an extension function such as
the instr for your purposes.
hth
Alexander Skwar <[EMAIL PROTECTED]> wrote: Daniel Önnerby schrieb:
> This should be a simple task for any programming language to do once the
> results has been retrieved.
Yes, of course. But it would be nice, if that could be done
on SQL level.
> With the current expressions in SQLite I believe there is no way to do
> this unless you extend SQLite with your own "string_find_last" or
> "replace_last" function.
Thanks. That's what I figured out as well :) Thanks
a lot for confrming this!
Alexander Skwar
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
