foundset filter / SQL

Classic Servoy
1

I looking for appropriate SQL for a foundset filter…

SELECT table.fieldName FROM table WHERE table.fieldName IN arrayName

Can this work if arrayName contains just the first 7 characters of a longer string in fieldName? Can this be expressed in the filter?

Thank you,
Don

2

Have you tried substring on table.fieldName?

3

I didn’t know that SQL had a substring command. Foolish me!

Thank you,
Don