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;

ONly Test4 returns TRUE!

Please refund us our 2 points!!! 😀

Yama Kamyar