• Welcome to SQLitening Support Forum.
 

News:

Welcome to the SQLitening support forums!

Main Menu

The LIKE Operator

Started by Fredrick Ughimi, April 18, 2014, 04:03:50 PM

Previous topic - Next topic

Fredrick Ughimi

Hello All,

I can't seems to make this work:


Local sDescription As String
Control Get Text nCbHndl, %ID_FORM2_TXTSEARCH To sDescription
slSEL "SELECT * from tblEateryMainInventory WHERE Description LIKE '%sDescription'"


Any suggestion would be helpful.
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet

Fredrick Ughimi

I was able to solve it:


slSEL "SELECT * from tblEateryMainInventory WHERE Description LIKE '" + sDescription + "%'"
Fredrick O. Ughimi<br /><br />fughimi@gmail.com<br />- Freedom lies in being bold -- Robert Frost, Poet