The query shows "value1", not "Value1", which definitely depends on case sensitivity.

however, in any case, "value1" is less than "value2" and the others. Your example bends the rows into columns. This is what the question asked:

/****** 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]