General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
Processing parameters in TransAct SQL
select *
from #my_vars
where sec_type in (select @new_type)
Variable @new_type contains different values (Ex. string1, string2, or "string1","string2") to match one or the other or both. When the var contains string1 or string2, it works. When it contains the combo (this is how I assign the value)
select @new_type = '"string1","string2"'
it doesn't work.
If I hard code the combo in the where clause, like this:
where sec_type in ("string1","string2")
it works.
Maybe it's the version of Sybase that I'm running?..
Thank you,
- Dmitry