Spectrum Spatial (SSA/LIM)

?Hi @[Andy d'Andilly]? ,

I was running through the release notes and am a touch confused by this bullet point within The limitations section "spectrum Spatial Analyst Administration Console"

"MSSQL Server does not support IN operator for VarChar and text whereas it is supported for other text formats like Char, varChar etc."

-- Microsoft Sql Server -- MSSQL im pretty sure there's only one varchar , there is however nvarchar

-- the IN operator seems to works fine for varchar and text data types

-- is the documentation referring to MISQL having these restraints

Maybe i'm missing some context around this as I haven't had any issues in this regard and I use varchar in MSSQL all the time 

Could you provide clarity around this please?

cheers

Hi Peter

We have verified this and the release note entry is incorrect. We will be removing that comment from the release note. The correct position I believe is as follows:-

• varchar, nvarchar, char, nchar are supported and should work fine with an IN operator
• text is not supported (by SQL server) with an IN or comparison operator
• ntext columns are not supported at all by Spectrum Spatial

Apologies for the confusion.

?Okay thanks that great to know.

cheers