Declaring Variables, LIKE and booleans-CodePudding

Can "LIKE" and a boolean behave the same way in a variable (IN SQL)? Or is there a way to do this?

I'm trying to declare a variable and have that variable be brought into my WHERE and everywhere else in my query.

DECLARE @SKU VARCHAR(10)
SET @SKU = LIKE 'RUSH%'

SELECT Name, SKU, Rate
FROM PriceTable
WHERE SKU = @SKU

CodePudding user response：

You can't do what you're trying to do. The variable is only a VARCHAR. It can't include logic.

This accomplishes the same thing, but the logic needs to be in the statements, not in the variable.

DECLARE @SKU_FILTER VARCHAR(10)
SET @SKU_FILTER = 'RUSH%'

SELECT Name, SKU, Rate
FROM PriceTable
WHERE SKU LIKE @SKU_FILTER