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%'
Thanks,
Andrés
--
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
