What is the SP equivalent of: SELECT * FROM Table WHERE 1 = 1 <CFIF a IS 1>AND ColumnA = 10</CFIF> <CFIF thisvar IS "No"> AND ColumnB IN (#A_List#)</CFIF> <CFIF orderby IS "Yes">ORDER BY ColumnC</CFIF>
Not this actual example but the principle as I can't see closing IFs in SPs.
