Using %IGNOREINDICES helped!

Thank you all :)

I tried using between but got the same result.

My property definition is as below:

Property Active As %Integer [ Calculated, Private, SqlComputeCode = { Set {Active}='$D(^ADZDICT("OS80",1,{HospitalCode},1,{LocationCode},"ACT"))
}, SqlComputed ];

I have a method:

Method ActiveGet() As %Integer
{
 Q '$D(^ADZDICT("OS80",1,..HospitalCode,1,..LocationCode,"ACT"))
}