Member Avatar for Fenerbahce

Hi,

SELECT *
FROM veriler
WHERE (name LIKE '%in%')

This line doesn't work in Ms Access, IN either. No error is given is well. But It works in SQL server. How can i do in Access?

Thanks

  • 2 Contributors
  • 2 Replies
  • 85 Views
  • 2 Months Discussion Span
  • Latest Post Latest Post by Henry Schubel
Member Avatar for Fenerbahce

answer is
WHERE name LIKE ('*' & in & '*')

commented: Good find! +1
commented: =D +4
Member Avatar for Henry Schubel

The Asterisk * is the wild card for the LIKE operator in Access.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.