Code is not producing the correct results.

Dear experts,
When I run the straight query on the database, I get the results correctly.
However, when I run the code on my .net app, some work but some don't work.
The code looks simple enough but I am not sure it is producing blank result.
Here is the code:
Dim suv As String = vpreferred.SelectedItem.Value 'Response.Write(val) 'Response.End() If ((val = "one_way_to_airport") Or (val = "one_way_from_airport") Or (val = "round_trip_airport") Or (val = "one_way_no_airport") Or (val = "round_trip_no_airport")) Then If suv = "SportUtilityVehicle" Then StrSQL = "select r.Newfare as Fare, r.tip, (r.total+12) as total from ratesQRY r " StrSQL += " Where r.city = @city " Else StrSQL = "select r.Newfare as Fare, r.tip, r.t ...