topic Re: What would be the SQL expression/code to hide some contour lines, using display filters in arcgis Pro 2.5.1? in ArcGIS Pro Questions https://community.esri.com/t5/arcgis-pro-questions/what-would-be-the-sql-expression-code-to-hide-some/m-p/324932#M14151 <HTML><HEAD></HEAD><BODY><P>From your screenshot, it looks like your back-end data store is SQL Server.&nbsp; If so, see <A class="link-titled" href="https://docs.microsoft.com/en-us/sql/t-sql/language-elements/modulo-transact-sql?view=sql-server-ver15" title="https://docs.microsoft.com/en-us/sql/t-sql/language-elements/modulo-transact-sql?view=sql-server-ver15">% (Modulus) (Transact-SQL) - SQL Server | Microsoft Docs</A> .</P></BODY></HTML> Tue, 26 May 2020 20:42:21 GMT JoshuaBixby 2020-05-26T20:42:21Z What would be the SQL expression/code to hide some contour lines, using display filters in arcgis Pro 2.5.1? https://community.esri.com/t5/arcgis-pro-questions/what-would-be-the-sql-expression-code-to-hide-some/m-p/324931#M14150 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>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&nbsp; multiples of twenty contour lines. Hope someone can give a hand discovering what is wrong with the sintaxis.&nbsp;</P><P>Thanks a lot!</P><P><IMG alt="SQL expression for a display filter to show only multiples of 20 contour lines" class="jive-emoji image-1 jive-image j-img-original" src="https://community.esri.com/legacyfs/online/493477_countours.jpg" /></P><P>Edu</P></BODY></HTML> Tue, 26 May 2020 20:15:40 GMT https://community.esri.com/t5/arcgis-pro-questions/what-would-be-the-sql-expression-code-to-hide-some/m-p/324931#M14150 JorgeFlores1 2020-05-26T20:15:40Z Re: What would be the SQL expression/code to hide some contour lines, using display filters in arcgis Pro 2.5.1? https://community.esri.com/t5/arcgis-pro-questions/what-would-be-the-sql-expression-code-to-hide-some/m-p/324932#M14151 <HTML><HEAD></HEAD><BODY><P>From your screenshot, it looks like your back-end data store is SQL Server.&nbsp; If so, see <A class="link-titled" href="https://docs.microsoft.com/en-us/sql/t-sql/language-elements/modulo-transact-sql?view=sql-server-ver15" title="https://docs.microsoft.com/en-us/sql/t-sql/language-elements/modulo-transact-sql?view=sql-server-ver15">% (Modulus) (Transact-SQL) - SQL Server | Microsoft Docs</A> .</P></BODY></HTML> Tue, 26 May 2020 20:42:21 GMT https://community.esri.com/t5/arcgis-pro-questions/what-would-be-the-sql-expression-code-to-hide-some/m-p/324932#M14151 JoshuaBixby 2020-05-26T20:42:21Z