Create Procedure GetUserInfo( inGroupID Int, inExtraInfo
VarChar( 32 ) )
Begin
   Select FName, LName, Address,... From Personel p
   Where ( inGroupID = 0 or p.GroupID = inGroupID )
        And ( Length( inExtraInfo ) = 0 Or inExtraInfo )
   Order by LName,FName;
End;

*** Note - How do I get the engine to use the content of inExtraInfo
for example if I wanted to pass in
a birthday as part of the where clause.  I am trying not to use
"pure" dynamic sql.

Any help will be appreciated.
Wayne