How do you handle wildcards when querying?

cv4bf5d65fd

Example: select * from tablename where column like '% [%]%'-this way you can find the rows that contain '%' in a column

Enlarging the "%" with brackets "[]" is considered a normal character

prajna

Why not use the charindex () function?

select * from # where charindex ('15% ', a)> 0

cv4bf5d65fd

select * from
(
select col = '15 '
union all select '% 15%'
union all select '% 15'
union all select '15% '
) a
where a.col like '% [%]%'

smallwarrior

select * from a where [name] like '% 15 [%]%'
select * from A where charindex ('15% ', [name])> 0 pairs

261150304

Use the ESCAPE keyword to define escape characters. In the pattern, when the escape character is placed before the wildcard, the wildcard is interpreted as a normal character. For example, to search for a string containing 5% of the string anywhere, use:
WHERE ColumnA LIKE '15/%%' ESCAPE'/'

261150304

Use the ESCAPE keyword to define escape characters. In the pattern, when the escape character is placed before the wildcard, the wildcard is interpreted as a normal character. For example, to search for strings that contain 15% of the string anywhere, use:
WHERE ColumnA LIKE'%15/%%' ESCAPE'/'

jccg1124

Learned learned