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, > > Andrés > > -- > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org/ Carbon Model http://carbonmodel.org/ Charter Member, Open Source Geospatial Foundation http://www.osgeo.org/ Science Commons Fellow, Geospatial Data http://sciencecommons.org Nelson Institute, UW-Madison http://www.nelson.wisc.edu/ ----------------------------------------------------------------------- collaborate, communicate, compete ======================================================================= Sent from Madison, WI, United States _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
