https://community.esri.com/t5/arcgis-pro-questions/arcade-sql-filter-fields-w-apostrophes-and/m-p/1357404#M75998 <P>You can substitute a Arcade variable in the sql statement like this</P><LI-CODE lang="javascript">var Park_Name = $feature.PARK_NAME; var results = Filter(athleticfields, "Name_Primary = @Park_Name");</LI-CODE><P>In my testing, this was able to filter attributes that contain apostrophes and parenthesis.</P> Wed, 06 Dec 2023 15:44:13 GMT KenBuja 2023-12-06T15:44:13Z https://community.esri.com/t5/arcgis-pro-questions/arcade-sql-filter-fields-w-apostrophes-and/m-p/1357373#M75993 <P>Here is my SQL filter statement that fails/errors.&nbsp; Both field names (Name_Primary and PARK_NAME) have apostrophes and parentheses in them.&nbsp; How would I form this statement to escape those characters?</P><P>&nbsp;</P><P>var results = Filter(athleticfields, "Name_Primary = '"+$feature.PARK_NAME+"')</P> Wed, 06 Dec 2023 15:39:07 GMT https://community.esri.com/t5/arcgis-pro-questions/arcade-sql-filter-fields-w-apostrophes-and/m-p/1357373#M75993 ArmstKP 2023-12-06T15:39:07Z https://community.esri.com/t5/arcgis-pro-questions/arcade-sql-filter-fields-w-apostrophes-and/m-p/1357404#M75998 <P>You can substitute a Arcade variable in the sql statement like this</P><LI-CODE lang="javascript">var Park_Name = $feature.PARK_NAME; var results = Filter(athleticfields, "Name_Primary = @Park_Name");</LI-CODE><P>In my testing, this was able to filter attributes that contain apostrophes and parenthesis.</P> Wed, 06 Dec 2023 15:44:13 GMT https://community.esri.com/t5/arcgis-pro-questions/arcade-sql-filter-fields-w-apostrophes-and/m-p/1357404#M75998 KenBuja 2023-12-06T15:44:13Z