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