SQL question

Peter Haworth pete at lcsql.com
Wed Sep 19 01:40:27 EDT 2012


I'm not sure that will work.  If Column2 started with "MyCriteria", I don't
think it would be selected.  Any queries of the form LIKE '%mycriteria%'
would work though.

Klaus, have you implemented a solution to this yet?  I don't recall you
mentioning which flavor of SQL you're using and that makes a difference.

Pete
lcSQL Software <http://www.lcsql.com>



On Tue, Sep 18, 2012 at 8:13 PM, Mark Stuart <mfstuart at cox.net> wrote:

> Klaus try concatenating the columns like this:
> SELECT Column1, Column2, Column3 FROM Table WHERE (Column1 + Column2 LIKE
> 'MyCriteria%')
>



More information about the use-livecode mailing list