What is the equivalent syntax of select...case in a stored procedure? I know I can use if, but I need to choose from 3 selections to run another query so a simple if..else won't work.<BR><BR>
What database? I know you can use IF...ELSE IF...ELSE statements in SQL Server 7.0. I don't know if there's an actual SELECT CASE, since SELECT is used to declare variables, but hey, it's a start :)
on a Friday, but you do have a select case...<BR><BR><BR>CASE some statment<BR> WHEN somevalue THEN ...<BR>END<BR>
... and promptly forget why I bookmarked it by Monday :) Thanks for pointing that out DG.