E.g,

@myWhere = varchar(200)

AS

SELECT x, y FROM skwi WHERE @myWhere

myWhere = status = 7 AND LastName = 'Smith'

The problem is that the where clause is built conditionally in the program.

Any advise and examples on how to accomplish would be appreciated.

Tom

"md Webs Unlimited" <NoN...@NoAddress.com> wrote in message
news:%232oGOhhNIHA.292@TK2MSFTNGP02.phx.gbl...

The right answer is to get out that old text book on Software
Engineering and the chapters on coupling and cohesion of code
modules.  Those rules still apply in SQL.

You are writing a "Britney Spears, Automobiles and Squids" module  --
you have no idea what it will do at run time, so it has absolutely no
cohesion.  Instead of depending on every random future user to write
proper SQL, you need to earn your salary and proper them with a well-
defined module with a meaningful name and a known parameter list.