The following sql query (simplified to get relevant with the error) -
"select tbldt.* from tabl tbldt where tbldt.DatingID in ( 63, 64, 67, 50)"
returns empty set, Although the table tabl contains the record with DatingID 67 .
Actually it should return all the rows having DatingID like anythng in the list.
Thanks & Regards,