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

Subject	Using % works for LIKE and not for IN ()
Author	venussoftop
Post date	2013-02-16T14:52:02Z

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