Finding Rows containing % symbol in a table [duplicate]

Question

How to find rows that contains '%' symbol in a column of table.

For example, I have a column containing data as 'amylase 50% of dose'.

How to select and filter all the rows containing % symbol in a given column?

Answer 1

try this query

select * from tablename where columnname like '%[%]%'

Answer 2

You can use WHERE Id LIKE '%[%]%'. An example will be something like this:

CREATE TABLE #Test
(
Id NVARCHAR(100)
)

INSERT INTO #Test VALUES ('100%'), ('1000')

SELECT * FROM #Test
WHERE Id LIKE '%[%]%'

DROP TABLE #Test

OUTPUT:

Id
100%