String case problem

From: "vishal" <vishalkumarjain@xxxxxxxxx>
Date: 29 Nov 2005 23:33:21 -0800

I am using a select statement like
SELECT ENAME FROM EMPTABLE WHERE ENAME ="vishal"

I am getting the result as 1 row affected.

Ename
----------
Vishal

The Problem is the query I have passed is "vishal"(lower case) and
getting the output as "Vishal"(V is Upper Case)

How do I solve this problem if I want to go with case sensitive
retrival of data.

I have gone thru some string functions available but could not find
one.
Any help would be appreciated..

regards
vishal.

.

Follow-Ups:
- Re: String case problem
  - From: Jens
- Re: String case problem
  - From: MC

Prev by Date: accessing mssql in linux through c++ code
Next by Date: Re: String case problem
Previous by thread: accessing mssql in linux through c++ code
Next by thread: Re: String case problem
Index(es):
- Date
- Thread

Relevant Pages

Re: String case problem
... Another workaround I used in SQL 7.0 a lot would be: ... SELECT ENAME FROM EMPTABLE ... Markus ... Prev by Date: ...
(comp.databases.ms-sqlserver)
Re: extract Top Ten order by date
... from (select ename from emp order by ename) ... ADAMS ... Prev by Date: ...
(comp.databases.oracle.misc)