This may be confusing but I am hoping someone can help. So I am trying to pass a string variable into an SQL query but I believe the quotes are messing it up. For example:
When I don’t use a parameter and I just pass in the values (‘dog’),(‘cat’) it works fine. But when I build that same string into a variable to use as a parameter (AnimalString), it adds double quotes around the string that seem to be causing the issue.
Can anyone help with this? Thanks