Why does SQL LIKE not work in Microsoft Access?

Question

I want to make a make request and request such things

select * from table where col like '%vkvk%' 

But with trial and error, I came to the conclusion that access does not work with LIKE or wildcard operators. Does anyone have any other solutions, because I'm not that accessible, so I really don't know.

Answer 1

Try:

select * from table where col like '*vkvk*'

Use an asterisk for a wildcard.

Answer 2

If you want to use some kind of SQL syntax similar to SQL Server, go to your access options and set it to "SQL 92" mode. As far as I know, this does two basic things (there may be others):

• % _ Jet SQL * ?.

• :

  SELECT MyTable.*
  FROM (SELECT * FROM SomeTable) As MyTable
  

... Jet:

   SELECT MyTable.*
   FROM [SELECT * FROM SomeTable]. As MyTable

... , , Jet.

, , SQL Server, SQL 92. , Access Access/Jet/ACE, , .

EDIT:

, , SQL 92 Access. , :

• , , SQL, SQL 89, ( SQL 92).

• ( Access). , Autoexpend/autoselect.

, , SQL 92 , - SO , . , , SQL 92 .

, SQL 92 Access - . , , , Access , .

Answer 3

like '%kvk%'

Access 2010 SQL Server (2008)

'*kvk*'

Answer 4

"Like" ( VB.NET MS-ACCESS 2010), - , , . ? .

, :

SELECT dbFieldDisplayName FROM dbTableName WHERE dbFieldSearchName 'A *'

:

SELECT dbFieldDisplayName FROM dbTableName WHERE dbFieldSearchName> = 'A' And dbFieldSearchName <'AZZZ'