Generally ProgramFuzzy search is written as follows:
Select * from table where txttitle like '% %'
Whether the connected database is access or SQL Server
However, when I write a program recently, the statements are always correct, but they are the result of the explain statement. For example, manually setting server security and thinking, it is mentioned that I always seek results when writing service queries. After a long time, this problem occurs many times. I found a problem. If it is correct to write it into the program as mentioned above, however, if you use the "query" function in access, you will find thatCodeBut it cannot run. Why? Why is the call in the program normal? search online and OK. It seems that Google or baidu should be available if there is a problem in this year, the "query" in the original access does not support fuzzy queries like '% Liu Yong %', which is equivalent to % of the wildcard: *, so it should be changed
Select * from table where txttitle like '* *'
The SQL Server Query analyzer still supports writing normal SQL statements. I don't know if this access method is haorni.
In addition, I often use the "query" function of access to operate directly in the database. Why haven't I found this problem after using it for so long? Is it because you can leave the program alone when you discover the problem, or haven't found it at all? I think I have discovered that the project may be too tight, so I didn't study it.