In case you missed something try:
strRS = LCase(rs("Cname"))
...
if(strRS = ss) then
response.write("exists")
else
response.write("new record")
end if
----- Original Message -----
From: "Jegatha" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Wednesday, July 06, 2005 2:23 AM
Subject: Re: [AspClassicAnyQuestionIsOk] check case
> ya Balaji,i changed database strings into lowercase
> as well i checked using LCase function
> a=request.form("name")
> ss=LCase(a)
>
> if(rs("Cname")=ss) then
> response.write("exists")
> else
> response.write("new record")
> end if
>
> Balaji vishnubhotla <[EMAIL PROTECTED]> wrote:
> Hi Jegatha,
>
> U please convert the input Sharp,SHarp,etc to any one case (lcase or
> Ucase) and do the same with the Database field which u are comparing
> with and then compare.
>
> For eg.
>
> If lcase("myinput") = lcase(rscheck("myfield")) Then
> Response.Write "Input Value Available in Database"
> Else
> Response.Write "Input Value Available in Database"
> End If
>
>
> All the Best
>
> --
> Balaji V
>
>
> ---------------------------------
> YAHOO! GROUPS LINKS
>
>
> Visit your group "AspClassicAnyQuestionIsOk" on the web.
>
> To unsubscribe from this group, send an email to:
> [EMAIL PROTECTED]
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
>
> ---------------------------------
>
>
>
>
> ---------------------------------
> Too much spam in your inbox? Yahoo! Mail gives you the best spam
> protection for FREE!
> http://in.mail.yahoo.com
>
> [Non-text portions of this message have been removed]
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
