Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Dynamic where clause help please
0 views
Skip to first unread message
wayne
Jul 22, 2008, 7:56:01 PM7/22/08
to
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;
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
0 new messages