Pass multiple string values to a database query parameter

In this example, a SQL query has a parameter:

SELECT * FROM table1

WHERE state IN @state

The string value provided to the parameter must be wrapped in quotes:


To pass multiple, delimited values, you must insert a break character (!) so InfoBurst will pass the quotes with the query:

!'California','New York'

Login or Signup to post a comment