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:


'California'


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