I built the access data table have some special symbols such as "", use the SQL query is how to ignore these special symbols

CodePudding user response:

Looks special, actually not special

CodePudding user response:

Don't understand the meaning of the building Lord, if it is a condition, can in the parameter assignment is removed

CodePudding user response:

Say not clear, such as "" position is fixed,

CodePudding user response:

Using the fuzzy query, query ", "best or don't let the" "inventory,

CodePudding user response:

Use ASCII remove special characters

CodePudding user response:

Replacement string
The replace (string, the string to be replaced, replace the string)

Select the replace (' the HelloWorld! ', 'o', 'e'), the result is: the HelleWerld!