P Kishor wrote:
> 2009/6/4 "Andrés G. Aragoneses" <kno...@gmail.com>:
>> 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%'
>>
>
> Sure, but wouldn't it be easier and quicker for you to just try it
> yourself than ask? Don't be afraid. Try it out. SELECTs can't harm
> your database.
Thanks, I had to run and didn't have time to test it at that moment :P
Andres
--
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
