problem to find record between perticular value

hi all,
I wanna find record in between particular range of value.

e.g. i want to find all the records whose RBI is between 10 to 50
my query is,
query = "select * from Offense where RBI= (select RBI from Offense where RBI between "+rbiv1+" and "+rbiv2+" and FirstName <>'"+str1+"' and LastName <>'"+str2+"')";

sub query return null,due to which I can't get the resulting records.

Please tell me what is the mistake in this query.

How to write query to access value between two ranges?

Thanks
vikas

re: problem to find record between perticular value

try using the following

query = "select * from Offense where RBI in (select RBI from Offense where RBI between "+rbiv1+" and "+rbiv2+" and FirstName <>'"+str1+"')" and LastName <>'"+str2+"'";

re: problem to find record between perticular value

Hi,

Without "IN"

query = "Select * from Offense where RBI between " + rbiv1 + " and " + rbiv2 + " and FirstName <> '" + str1 + "' and LastName <> '" + str2 + "'";

Regards
Veena