"Ulrich Schöbel" <[email protected]> wrote in message news:[email protected] > I have a very simple table 'friends' with only one column > 'link': > > create table friends (link text); > > Lets assume there are 2 rows, 'abc' and 'def'. > > Then there is a Tcl variable x containing a string. If $x > starts with either abc or def (if $x starts with any value > in the table) I want a TRUE value (or something > comparable) otherwise a FALSE.
select exists (select 1 from friends where ? like link || '%'); Igor Tandetnik
_______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
