How to filter out the percent sign of sql statement?

tc张扬

Everyone knows that percent signs ("%") are wildcard characters in SQL statements.

Now there is a TextBox input box on the screen, and the program searches the database according to the value of this input box as a query condition.
At this time, if you enter a percent sign ("%"), you do not want to retrieve all the data. So you need to filter it out.

Masters please help, is there a way to filter out the percent sign ("%")?

In addition, if there is data with percent sign ("%") in the database, entering the percent sign ("%") should be able to find out that piece of data.

Wait for the answer online!

zeus0924

Tried with escape characters
TextBox.text = Replace (TextBox.text, "%", "\%")

tc张扬

Can not do it

tsh6969

TextBox.text = Replace (TextBox.text, "%", "[%]")

tsh6969

Special characters are treated with left and right brackets

tc张扬

Right

Square bracket filtering is only effective in the DataView's RowFilter, right?

I'm talking about how to filter percent signs in SQL statements.

自然啊

Is TextBox.text = Replace (TextBox.text, "%", "[%]")

tsh6969

Halo, you try the difference between select * from table where field like 'a%' and select * from table where field like 'a [%]', actually said that SQL does not support it. . . .

tsh6969

The landlord didn't even try it and said no, depressed. . . . . . .

yuleisme

select * from table where aa like'liu&%' escape '&'
Set the escape character.