CREATE TABLE [dbo].[Table_1](
    [RID] [int] IDENTITY(1,1) NOT NULL,
    [XVALUE] [int] NULL,
    [YVALUE] [int] NULL,
 CONSTRAINT [PK_Table_1] PRIMARY KEY CLUSTERED 
(
    [RID] ASC
)WITH (PAD_INDEX  = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]


SELECT * FROM Table_1 WHERE XVALUE BETWEEN 5 AND 8
SELECT * FROM Table_1 WHERE YVALUE BETWEEN 5 AND 8


DECLARE @kolon INT
SET @kolon=1
SELECT * FROM Table_1 WHERE 
  CASE WHEN @kolon=0 THEN XVALUE ELSE YVALUE END
BETWEEN 5 AND 8




İsmail Kocacan(Yazılımcı Bozuntusu) ismailkocacan@gmail.com