UCMDB Tips: How to search a string which contains []

Query:

 

When using SQLServer 2008 R2, the property name which contains [], like node[10] – name, node[20] – name, no CI can be retrieved properly.

 

 

Solution:

 

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. 

 

Best Regards, 

Jun