Solution to access fuzzy query failure

Source: Internet
Author: User
Tags sql server query

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.