Igor Tandetnik wrote: > "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 >
Wow! Nifty! Thanks Igor. Regards Ulli _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users