Re: [sqlite] Concat two fields for LIKE query?

[Andrés G. Aragoneses]

Igor Tandetnik wrote:
> "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 +.
> 

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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users