Hi ,

you can use the following statement

select .... from users where username='abc' and cast(rtrim(password) as
varbinary)=cast('fieldname' as varbinary)

The casting to varbinary does the trick


Akash.

-----Original Message-----
From: bounce-aspx_professional-1184710@p...
[mailto:bounce-aspx_professional-1184710@p...]On Behalf Of
ramprasad upadhyaya
Sent: Wednesday, September 25, 2002 8:30 AM
To: ASPX_Professional
Subject: [aspx_professional] To check Password case sensitiveness


Hi friends...

	I am developing an ASP.NET web application with SQL Server 2000 as
backend. For which i have
a login page where i have to validate user name and password. My doubt is
how to Check passowrd field
case sensitiveness with sql server 2000 . Please send me solution..

Waiting for Response
Ramprasad Upadhyaya
---

ASP.NET 1.0 Namespace Reference with C#
http://www.wrox.com/acon11.asp?ISBN=1861007442

ASP.NET 1.0 Namespace Reference with VB.NET
http://www.wrox.com/acon11.asp?ISBN=1861007450

These books are a complete reference to the ASP.NET namespaces
for developers who are already familiar with using ASP.NET.
There is no trivial introductory material or useless .NET
hype and the presentation of the namespaces, in an easy-to use
alphabetical order ensures a user-friendly reference format.
We provide in-depth coverage of all the major ASP.NET classes,
giving you those real-world tips that the documentation doesn't
offer, and demonstrating complex techniques with simple
examples.

---