Stored Prodcedure variable where

CASE @in_type             
     WHEN 'total'         THEN SET @colname = 'CreateDate';             
     WHEN 'new'           THEN SET @colname = 'StartDate';             
     WHEN 'expire'        THEN SET @colname = 'ExpireDate';        
END CASE;

SELECT * FROM txorderlines WHERE @colname=@date

CASE @in_type             
     WHEN 'total'         THEN SET @colname = 'CreateDate';             
     WHEN 'new'           THEN SET @colname = 'StartDate';             
     WHEN 'expire'        THEN SET @colname = 'ExpireDate';        
END CASE;
 
SELECT * FROM txorderlines WHERE @colname=@date

SELECT id, poster, bericht, tijd FROM tbl_berichten WHERE id = @id
RETURN

SELECT id, poster, bericht, tijd FROM tbl_berichten WHERE id = @id
RETURN