2 Replies Latest reply on Jun 15, 2006 12:21 AM by BKBK

    where clause

    richy2424 Level 1
      Hi i have this where clause

      WHERE
      Season = <CFIF isdefined ("FORM.Years")>'#FORM.Years#'<CFELSE>2</CFIF>

      this works but what i need to do is if the form is not defined then = the maximum of the column

      eg if in the column was 1,1,2,2,3,3
      then = 3

      can this be done?