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