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



When using SQLServer 2008 R2, the property name which contains [], like node[10] – name, node[20] – 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. 


Best Regards,