CODEWITHSUNDEEP
sqlms-access-2010
JeepGirl
JeepGirl

Reputation: 21

Access Database query on finding specific character in a sentence

I'm looking to find specific characters a column that has addresses. So this has numbers, characters and spaces. Using "like" does not seem to work. I tried using "instr," but I can't get it right....Is it because it has spaces?

So for example: 1234 Arlington Hwy

I want to pull up any address records that has "Hwy" in it. Help please!

Upvotes: 0

Views: 650

Answers (1)

Kade M.
Kade M.

Reputation: 181

SELECT * FROM mytable
WHERE column1 LIKE '*Hwy*'

The * operator acts as a wild-card, allowing anything to come before and after "Hwy" to return.

Upvotes: 2

Related Questions