Wild card in SelectSQL with LIKE operator

Databases
1

I get how to use a wild card as follows:
rSet = db.SelectSQL("SELECT * FROM Persons WHERE Name = " + FindPropValue)
rSet = db.SelectSQL(“SELECT * FROM Persons WHERE Name = ?”, FindPropValue)

But how can I use a wild card if I need to LIKE ‘BOB%’ as follows:
rSet = db.SelectSQL(“SELECT * FROM Persons WHERE Name LIKE '” + FindPropValue + “%’”)

Is there a way to do this?

Thanks

2

rSet = db.SelectSQL(“SELECT * FROM Persons WHERE Name LIKE ?”, FindPropValue + “%”)

1 Like