hi
i have five colums which has data type int, i have selected row on the basis of primary key, but now in this row i want to select particular column with name which has value less than some int value.
the resulted column is any in this five column
please help me i find no solution for that on google also i have that table i want to select the column name (which is one among first age,second age,thirdage,fourth age,fifth age) which has the value let assume <20
USE [MedicalLabDB]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Advance_Sub_Tests](
[Advance_Sub_Test_ID] [int] IDENTITY(1,1) NOT NULL,
[Sub_Test_ID] [int] NULL,
[L_Bound_M_LessThan_First_Age ] [float] NULL,
[U_Bound_M_LessThan_First_Age ] [float] NULL,
[L_Bound_M_LessThan_Second_Age] [float] NULL,
[U_Bound_M_LessThan_Second_Age] [float] NULL,
[L_Bound_M_LessThan_Third_Age] [float] NULL,
[U_Bound_M_LessThan_Third_Age] [float] NULL,
[L_Bound_M_LessThan_Fourth_Age] [float] NULL,
[U_Bound_M_LessThan_Fourth_Age] [float] NULL,
[L_Bound_M_LessThan_Fifth_Age] [float] NULL,
[U_Bound_M_LessThan_Fifth_Age] [float] NULL,
[L_Bound_F_LessThan_First_Age] [float] NULL,
[U_Bound_F_LessThan_First_Age] [float] NULL,
[L_Bound_F_LessThan_Second_Age] [float] NULL,
[U_Bound_F_LessThan_Second_Age] [float] NULL,
[L_Bound_F_LessThan_Third_Age] [float] NULL,
[U_Bound_F_LessThan_Third_Age] [float] NULL,
[L_Bound_F_LessThan_Fourth_Age] [float] NULL,
[U_Bound_F_LessThan_Fourth_Age] [float] NULL,
[L_Bound_F_LessThan_Fifth_Age] [float] NULL,
[U_Bound_F_LessThan_Fifth_Age] [float] NULL,
[First_Age] [int] NULL,
[Second_Age] [int] NULL,
[Third_Age] [int] NULL,
[Fourth_Age] [int] NULL,
[Fifth_Age] [int] NULL,
[Test_Active] [bit] NULL,
[Version] [timestamp] NULL,
CONSTRAINT [PK_Advance_Sub_Test_1] PRIMARY KEY CLUSTERED
(
[Advance_Sub_Test_ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]