Filtering With Multi-Select Boxes With SQL Server

SELECT
     my_column
FROM
     My_Table
WHERE
     @my_string LIKE '%|' + my_column + '|%'

/*
    Name:		GetTableFromStringList
    Description:	Returns a table of values extracted from a delimited list
    Parameters:
    		@StringList - A delimited list of strings
    		@Delimiter - The delimiter used in the delimited list

    History:
    Date		Name			Comments
    ----------	-------------	----------------------------------------------------
    2008-12-03	T. Hummel	Initial Creation
*/
CREATE FUNCTION dbo.GetTableFromStringList
(
    @StringList	VARCHAR(1000),
    @Delimiter	CHAR(1) = ','
)
RETURNS @Results TABLE
(
    String	VARCHAR(1000)	NOT NULL
)
AS
BEGIN
    DECLARE
    	@string		VARCHAR(1000),
    	@position	SMALLINT

    SET @StringList = LTRIM(RTRIM(@StringList)) + @Delimiter
    SET @position = CHARINDEX(@Delimiter, @StringList)

    WHILE (@position > 0)
    BEGIN
    	SET @string = LTRIM(RTRIM(LEFT(@StringList, @position - 1)))

    	IF (@string <> '')
    	BEGIN
    		INSERT INTO @Results (String) VALUES (@string)
    	END

    	SET @StringList = RIGHT(@StringList, LEN(@StringList) - @position)
    	SET @position = CHARINDEX(@Delimiter, @StringList, 1)
    END

    RETURN
END

<option value="3">Car</option>
<option value="4">Carpret</option>

SELECT * FROM tblTable WHERE option IN (selected_option_1, selected_option_2, selected_option_n)