IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Table_1]') AND type in (N'U'))
DROP TABLE [dbo].[Table_1]

/****** Object:  Table [dbo].[Table_1]    Script Date: 06/20/2008 08:46:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_1](
        [column1] [nchar](10) NULL,
        [column2] [nchar](10) NULL,
        [column3] [nchar](10) NULL,
        [column4] [nchar](10) NULL
) ON [PRIMARY]


INSERT [Table_1] 
        ([column1], [column2], [column3], [column4]) 
VALUES 
        ('Value1', 'Value2', 'Value3', 'Value4')


IF 'Value1' < ANY ( SELECT [column1] FROM [Table_1] ) 
        SELECT '1' TEST1
ELSE 
        SELECT '0' TEST1;

IF 'Value4' < ANY ( SELECT [column1] FROM [Table_1] ) 
        SELECT '1' TEST2
ELSE 
        SELECT '0' TEST2;

IF 'Value4' = ANY ( SELECT [column1] FROM [Table_1] ) 
        SELECT '1' TEST3
ELSE 
        SELECT '0' TEST3;

IF 'Value1' = ANY ( SELECT [column1] FROM [Table_1] ) 
        SELECT '1' TEST4
ELSE 
        SELECT '0' TEST4;

/****** Object:  Table [dbo].[Table_1]    Script Date: 06/20/2008 08:46:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Table_1](
        [column1] [nchar](10) NULL
) ON [PRIMARY]

INSERT [Table_1] ([column1]) VALUES ('Value1')
INSERT [Table_1] ([column1]) VALUES ('Value2')
INSERT [Table_1] ([column1]) VALUES ('Value3')
INSERT [Table_1] ([column1]) VALUES ('Value4')

select * from Table_1
IF 'Value1' < ANY ( SELECT [column1] FROM [Table_1] ) 
        SELECT '1' TEST1
ELSE 
        SELECT '0' TEST1;

Drop TABLE [dbo].[Table_1]