Extract by Attribute Won't Work

[ctraft]

I'm trying to use Extract by Attribute for a Tiff raster layer. The process completes and creates a new layer, but I don't see the data. Plus, the new layer has the same attribute table as the input layer. 

My where clause, in SQL format, is this: OID IN (12, 13)

Does anyone know what I might be doing wrong? 

[DuncanHornby · Accepted solution]

Firstly confirm your raster is indeed an INTEGER raster. I personally think it unusual to select cells by the OID, to me it would make more sense to select the cells by the VALUE field? I suggest you edit your existing question and add an actual screen shot of the attribute table to be crystal clear what you are using.

[ctraft]

OK, I had to convert it to an integer raster using the Int function in Spatial Analyst and then select cells by Value field in Extract by Attributes. I thought it was an integer raster, because the values were all whole numbers. Thanks!