SELECT .... LIKE doesn't work

[Guest]

String cstr = "select * from tFam where name like \'" + tFind.Text + "\' order by name, fname"

Directed to Access DB
Works fine when tFind.Text = "nelson" but returns nothing when tFind.Text = "*son". Same behavior with single or double quotes around the find text. What's up

Thanks
Eric

 

[Guest]

OK, so where was I supposed to find out it's the PERCENT sign for wildcard with OleDb??
It's the splat (*) in Access!

Is there an OleDb equivalent to the (?) in Access, i.e. match one character

Sigh..

Eric

 

[CT]

Yes, it's the underscore character _

 

[Guest]

THanks CT
Other than here, where should I have learned that
E

 

[kdub]

I think its basic TSQL. MS Access uses its own flavor of Structured Query
Language Syntax.

Just a tip:

single quotes and + sign is how you concatenate strings.

'hello ' + 'world.'

 

[JLW]

That's TSQL-99 language. I _ (Underscore) is wild for one charactor, but
what if you needed to find everything that started with Tre? Use Like
'Tre%'. You can download the SQL Server Books On-line, it's a great
reference and you don't have to have SQL server installed to use the BOL

HTH
JLW

String cstr = "select * from tFam where name like \'" + tFind.Text + "\' order by name, fname";

Directed to Access DB.
Works fine when tFind.Text = "nelson" but returns nothing when tFind.Text

= "*son". Same behavior with single or double quotes around the find text.
What's up?