Problem with brackets

[Guest_imported]

Hello,
my problem is that i have in my table string fields containing brackets inside exp: arr[1].
Whenever i use a Select query with a
WHERE FIELD LIKE 'arr[1]'
i get no result.
I know the problem is coming from Brackets but what should be done in order to get the right results from the query.
Thanks

 

[Tim1]

Hiya,

The problem is that SQL uses square brackets as a wildcard in queries, so you could look for numbers between 071 and 074 by doing

WHERE field LIKE '07[1-4]%'

What you need to do for a literal search using any wildcard is to use = not like

so, you need WHERE FIELD= 'arr[1]'

HTH

Tim

 

[tlbroadbent]

You can search for left brackets by enclosing them in brackets. Otherwise, SQL Server treats brackets as ESCAPE characters.

Select * from table
where field like 'arr[[]1]%'

You can also designate a different ESCAPE character.

Select * from #t
where field like 'arr/[1]%' ESCAPE '/' Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.