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