[firebird-support] Using % works for LIKE and not for IN ()

[venussoftop]

Hi all

When using LIKE I can use the 'String%' to look for partial matches. Not so 
when I want to use IN ('String%', 'VariousString%') instead I have to use 2 
LIKEs

Is there something I missed for using IN ()?  That would allow me to use 
partial matches?  The IN keeps the query simpler and shorter than multiple 
LIKEs IMO. 

Please advise

Thanks and regards
Bhavbhuti