I have a stored procedure. I need to insert some text directly into the WHERE clause. I really do not want to make the entire SQL statement a string and use macro substitution to execute it. Is there a way to accomplish what I want to do below?

The text that starts with && in the where clause is what I want to insert. The value of @DispositionText can be a lot of things. It is supplied by someone else's program that I have to work with. For example, the piece of code I'm tracing *right now* shows it to be this value: **" and (Missing = 1)"** But it can be any number of conditional checks that are out of my control.

```
    @AssetDesc varchar (30) = null,
    @DispositionText varchar(200) = null

...
    select *
       from Equipment
       where Equipment.Description = @AssetDesc 
       &&@DispositionText
       order by AssetDesc

```