"Bruno Moreira Guedes" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Yes... I need to get the rows where 'something' ENDS wifh > '.[field-value]'. But I really think this solution isn't very well.
Can field-value contain a period? If not, you can just extract the portion of 'something' after the last period, then run a straight comparison: WHERE somefield='tail-of-somestring' . Such a comparison can then be sped up with an index. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
