UCMDB Tips: How to search a string which contains 
When using SQLServer 2008 R2, the property name which contains , like node – name, node – name, no CI can be retrieved properly.
The character [ is a wildcard in SQLServer. So the string format being used in LIKE clause should be changed as below:
node[%] – name
Hope this tips would be helpful.
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
Click the KUDOS star on the left to say 'Thanks'