|
Posted by MC on 11/30/05 09:54
Check for the COLLATION in books online. Your setting is obviously CI (case
insensitive).
If you want just for the query to be case sensitive you can specify
collation in the select statement. Check for COLLATE option for this.
MC
"vishal" <vishalkumarjain@gmail.com> wrote in message
news:1133336001.203540.29810@g47g2000cwa.googlegroups.com...
>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.
>
Navigation:
[Reply to this message]
|