Issues with [ and ] in data 1

[tmar]

I have and item in my system with an ID of NP-M271x[chas] and I am unable to grab that item via a sql query like:

select * from timitem where itemid like 'NP-M271x[chas]'

From my testing I see the ['s are the issue but have no idea how to deal with them.

 

[MakeItSo]

Hi tmar,

you needd to escape the brackets either with brackets or with backslashes. I think backslashes are nicer to the eye:

http://stackoverflow.com/questions/8984380/sql-server-need-to-escape

;-)

Cheers,
MakeItSo

“Knowledge is power. Information is liberating. Education is the premise of progress, in every society, in every family.” (Kofi Annan)
Oppose SOPA, PIPA, ACTA; measures to curb freedom of information under whatever name whatsoever.

 

[DaveInIowa]

Since you're not using any wildcards, is there any reason you're using 'LIKE' instead of '='?

 

[tmar]

Very nice.

Thanks