access的通配符（Access wildcards）.docVIP

access的通配符（Access wildcards） Comparison of ACCESS and SQL SERVER wildcard wildcard =================================================== The ACCESS library for wildcard: * with any number of characters, ? with any single alphanumeric characters, SQL Server in as: Any number of characters% and matching _ and single character matching text When I wrote a page today, also very depressed, the table clearly documented, but in ASP is not search, the SQL statement theory as follows: SELECT FROM t_food WHERE t_ like * * * apple Go to GOOGLE search found that ASP fuzzy query should be written: SELECT * FROM t_food WHERE t_ like%% apple%% Must be %, but also to two. We pay more attention to. ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ SQL query wildcard problem Check the data with the SQL statement in Access, use the wildcard query. The statement is as follows: SELECT * from normal where bookname like*h* In the SQL view in the Access test without any problems, all normal work. The SQL statement is written to the C# program, the results of a query to wrong out, remain perplexed despite much thought. Then find the Access help file, find the following help: //////////////////////////////////////////////////////////// The string expression and SQL expression patterns were compared. grammar Expression Like pattern The Like operator grammar consists of the following parts: Part of that The SQL expression of expression used in the WHERE clause. Pattern and expression are strings of text comparison. Explain Can field through the Like operator to find and match the value of the specified pattern. For pattern, you can specify the complete value (such as Smith Like), can also use wildcards to find a range of values (such as Sm* Like). In the expression, you can use the Like operator to compare the field value and string. For example, if the input Like C* in the SQL query, the query returns all fields to the letter C value. The parameters in the query, can pr