SQL IN() function
bobsneidar at iotecdigital.com
Thu May 21 18:19:50 CEST 2015
that should read devicelist stupid spel corect. :-)
> On May 21, 2015, at 09:14 , Bob Sneidar <bobsneidar at iotecdigital.com> wrote:
> Hi all.
> I am having a problem with a query. I have the value “647,6480” in a column called devicelist. I use the query:
> SELECT * FROM formsgen.service where 647 in(device list);
> It returns one record as it should. However if I use the query:
> SELECT * FROM formsgen.service where 6480 in(device list);
> I get NO RECORDS. Am I misunderstanding the IN function? BTW the column is a BLOB type. Not sure if that matters.
> Bob S
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the use-livecode