Access do a fuzzy query always can not find the data, but the SQL statement on access can query data. The SQL statement is this:
Electric Division SELECT count (cash) FROM student WHERE banji = ‘5010 ‘and computer like’ * two * ‘and final = 1;
Tangled really bad, and why! ! “*” Represents obviously match 0 or more of the meaning of it, but why in access SQL statement can check out the results, but on the jsp page can not check out the results? ?
(“?” Means any single character; “*” means zero or more characters; “#” indicates a number)