using "LIKE" in access sql

[gotmilk2]

Whenever I use the 'LIKE' operator no data is return. Am i using it properly? example: Select * from sometable where somefield like 'B%'

 

[jebry]

Hi!

It depends what you are trying to do. If you want to return all records that the field starts with the letter b then you do this:

Like "B*"

the * means that there can be any number of characters after the b the % means that there is only one character after the b.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[PHV]

the % means that there is only one character
I disagree.
The % is the STANDARD wild character whereas * is the JetSQL/VBA one.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[jebry]

The % is the STANDARD wild character whereas * is the JetSQL/VBA one

That is of course correct but he specifically asked about Access SQL so I answered it that way. I hope that this did not confuse the asker.



Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[PHV]

So the JetSQL "unique character" is ? (not %)

 

[jebry]

Sorry

That is correct, I was getting my wildcards confused. The ? is the single character wildcard not %.

Good call PHV

Jeff Bridgham
Purdue University
Graduate School
Data Analyst