Case statements

Is the use of case statements allowed the Where clause when creating a row restriction in supervisor?


billbejeck (BOB member since 2004-06-03)

Sure, I would think so. There is a limit to how long a supervisor restriction can be, but I don’t believe that there is a limit to the SQL that you can use.


Dave Rathbun :us: (BOB member since 2002-06-06)

…and Steve has a cool workaround to circumvent the limitation :smiley:


Cindy Clayton :us: (BOB member since 2002-06-11)