I figured out what I was doing wrong.  I was assigning permissions to a new folder called Accounting within the Home folder.  I needed to add the permissions at the...

barsuk,

Haven't used the case statement in the WHERE clause, but you could use an OR statment to accomplish the same thing.

Select Cln_Num from Clients

WHERE ( (lowercase(@Cln_Num)='all') OR (Cln_Num = @Cln_Num) )

In...