Select to view content in your preferred language

What would be the SQL expression/code to hide some contour lines, using display filters in arcgis Pro 2.5.1?

887
1
05-26-2020 01:15 PM
JorgeFlores1
Emerging Contributor

Hi

I'm attaching the message that comes in ("The SQL expression has invalid sintaxis") when I write the SQL statement (SELECT * FROM SigCABH.DBOCurvasNivel1000 WHERE (MOD(ELEVATION,20)=0); )to just show  multiples of twenty contour lines. Hope someone can give a hand discovering what is wrong with the sintaxis. 

Thanks a lot!

SQL expression for a display filter to show only multiples of 20 contour lines

Edu

0 Kudos
1 Reply
JoshuaBixby
MVP Esteemed Contributor

From your screenshot, it looks like your back-end data store is SQL Server.  If so, see % (Modulus) (Transact-SQL) - SQL Server | Microsoft Docs .

0 Kudos