Like Operator

[aw23]

I know that this is simple but it's not working and I can't seem to find it in the search.

How do you use like?
The following is my query:
"select * from table where name like '%.%'"
and I get no results? What am I doing wrong?

Thanks

 

[aw23]

What I am trying to do is find all companies that have a . in them

 

[aw23]

I got it, thanks

 

[ZmrAbdulla]

Like "*" & "." & "*"
would do this

Zameer Abdulla
Visit Me
Where to pay your [purple]Tsunami[/purple] relief donations?

 

[aw23]

Thanks, I got it. But why * and not %?
Is % for sql and not access?

 

[ZmrAbdulla]

This is the common doubt those are experinced SQL and new to Access.
I am opposite a little experience in Access and NULL in SQL
I know * is used in Access not %


Zameer Abdulla
Visit Me
Where to pay your [purple]Tsunami[/purple] relief donations?

 

[Crowley16]

* is used for the jet sql, but % is used for adodb...

--------------------
Procrastinate Now!

 

[ZmrAbdulla]

Thanks Crowley16 for that info

Zameer Abdulla
Visit Me
Where to pay your [purple]Tsunami[/purple] relief donations?

 

[aw23]

Thanks