Need correct SQL syntax for command object

[sfx]

Hello All,

I was wondering if someone might be able to assist me with the correct syntax for a particular SQL statement when creating an OleDBCommand object? I am trying to locate anything similar to a parameter that is mapped to the SelectedItem of a ComboBox. An example of what I am attempting to do is below:

"WHERE BusinessName LIKE '%'[@BusinessName]'%'"

Can anyone help me with the correct syntax for this type of clause?

Cheers,

sfx

 

[TechGnome]

Need to concatenate the SQL together.

"WHERE BusinessName LIKE '%' + [@BusinessName] + '%'"

-tg

 

[sfx]

Thanks tg!

 

[TechGnome]

no prob... bill is in the mail...

-tg