"Andrés G. Aragoneses" <[email protected]> wrote: > Igor Tandetnik wrote: >> "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 +. >> > > Cool! And can I do this as well?: > > SELECT Path||Filename FROM SomeTable WHERE Path || FileName LIKE > '%user/File%'
Why wouldn't you try it and find out? Igor Tandetnik
_______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
