Assistance needed with SQL Syntax
Posted on 2007-11-21
I need some assistance with some code that I would like to expand on:
Here is the code:
if sModels.Text<>'ANY' then
'Select * from motors where (Make) = '
+ ' AND ((Model) LIKE "%'
+ ComboBox2.text //Fiesta
+ '%")' // %")
I need to add
AND (Price) <= PriceComboBox.text
also PriceComboBox.text is a String ....Do I need to Add StrToInt for it to work???
Hope you can help