Filter with integer field and LIKE

ply · Post by **ply** » Tue 27 May 2008 15:09

I neet to apply 'LIKE' filter to integer field:

client_id LIKE '%65%'

But error occurs: "Could not convert variant of type (String) into type (Double)"

jkuiper_them · Post by **jkuiper_them** » Wed 28 May 2008 07:49

I neet to apply 'LIKE' filter to integer field:

client_id LIKE '%65%'

But error occurs: "Could not convert variant of type (String) into type (Double)"

What you trying to do is not logical and isn't an iso standard of SQL.
The option LIKE is implemented for search on strings, so you can simular founded records. For integers, floats, decimals, and dates the option BETWEEN will be used. Or set your integerfield ti a stringfield. It's your choice.