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.