CS.ResourceId = SER.ResourceID
and CS.ResourceId = FCM.ResourceID
and SER.displayname0 like ‘%firewall%’
and (SER.State0 != ‘Running’ or Isnull(SER.State0,”)=”)
and FCM.CollectionID = ‘SMS00001′
I have an issue with the syntax in
Isnull(SER.State0,”)=”) or Isnull(SER.State0,’)=’)
the double quotes or single quotes did not work…
What could be the correct syntax?
the error is:
“An expression of non-boolean type specified in a context where a condition is expected “
Try wirh quotes ' where required. It looks like the blog convert the quotes to fancy quotes which is causing the issue.
hii. i also face same problem. can u help me ?
what is the issue you are having?
You need to replace the quotes with ''
Cool Information... Thanks!