"Andrés G. Aragoneses" <kno...@gmail.com> wrote: > My query, which I want to make it return the first row: > > SELECT * FROM SomeTable WHERE Path+FileName LIKE '%user/File%'
SELECT * FROM SomeTable WHERE Path || FileName LIKE '%user/File%'; In SQL, string concatenation operator is ||, not +. Igor Tandetnik
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
