I have a working stored procedure in sql that accepts a single parameter of @StateProvince which does work. From xmod pro I can execute the stored procedure and return all the values. The code below is an attempt to filter the results to just one state. If I can get this working I can move on to creating a prepopulated dropdown and pass the dropdown value with an onchange event.

The main issue is I am searching for the proper syntax but between the documentation, the forums and user examples it is just plain confusing as to how to structure the syntax.

Regards.