"Andrés G. Aragoneses" <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
