SQL IN() function

[Bob Sneidar]

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