If X is a subquery of components that need to be sent out for platting and @ITEM is a component and @ADJUSTMENT is a varriable I need to write something that does the following:

IF @ITEM IS IN X
SET @ADJUSTMENT = 7
ELSE
SET @ADJUSTMENT = 0

Help would be greately appreciated!

If you need to know, the subquery X returns nothing more or less than a list of items.

I'm not sure what you exactly want to retrieve, so here are some examples which I hope will help you.

couldn't you just do a select in the if statement like:

IF EXISTS(SELECT NULL FROM Table WHERE Item = @ITEM)

or if you need to use a subquery to check if the item is for example in a specific category which is in a other table:

SELECT NULL FROM Items WHERE Item = @ITEM AND ItemId IN (SELECT ItemId FROM ItemCategories WHERE Cat = @CAT)