"Ulrich Schöbel" <u...@bmu.office-on-the.net> wrote in message news:4997ddb2.9070...@bmu.office-on-the.net > 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users