Hi,
I need to create a user defined function to perform a
sanity check on an alphanumeric field , which should only
allow alphabets. It should return a code if the input is
alphabetic or not & also needs to consider special
characters.
It's urgent, need to do this today , pls help or share
the code incase anybody has already implemented it.
Thanks & regards,
Mercy
Answer / namrata
Put the input in a string variable. Then for each character
in the string, check its ASCII value...if its falls within
65 to 90(for capital alphabets-A to Z) or 97 to 122(for
small letters-a to z) then it is alphabetic. Else it is not.
| Is This Answer Correct ? | 5 Yes | 0 No |
You have 16 new CDs to put on your empty five-shelf CD rack. Can you place the CDs so that each shelf contains three or fewer CDs? Can you arrange them so that each shelf gets exactly three?
Which is the tallest building in the world?
what is the different between windows xp and Windows vista
Please send me all common interview questions. My Email Id: ramadurga_kumar@yahoo.com
Interviewer: This is a phone/pen. How you will sell this item to me?
Why does Google rank Wikipedia for so many topics? What are some challenges facing the SEO industry?
Can a Trust be made nominee in a life insurance policy
why the the name "MOGHAL" adopted as name of the dynasty?
WHEN WILL AXIS BANK ANNOUNCE THE RESULT FOR EXECUTIVES HELD ON 26TH APRIL2009, SOUTHERN ZONE?
I was been in the US before when my ex boyfriend petition a K1 visa but the relationship did not work so i went back to my country.Now i have a new boyfriend his American citizen can he still petition me for a K1 visa?
What is diff bet lotus and exchange and which is good in messing only?
How to choose generals in grand battle game? In grand battle game, I have upgraded to a certain level, which enables me to choose generals to fight for me. However, I am not sure how to choose them. Could any one can give me some suggestions? Thank you!