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 |
I want to know that as a employee, how should we introduce ourself in front of Company Director.
What is valley, Playa, Catchment area, Basin ? please describe with picture.
Any difficult situation which u have ever handled in the absence of ur team leader? would be better if answer is from BPO (Call centers)
is this sentence correct ??? " i had completed "
can i give both the schemes A n B of ssc gl(main) my preference is insp. in income tax/excise
What is the importance of gentlemanliness?
What do you think about link buying?
who is the murderer of shersaha?
GIVE AN IDEA FOR TRAINING/COURSES THAT WOULD HELP YOU TO SUCCEED IN YOUR JOB?
How can we See NTFS Partitions in Linux RHEL 5 plz give simple answer as possible
who is the cricter to score century in odi is the don bradman or other then this
WHAT IS THE DIFFERENCE BETWEEN EARTHING AND GROUNDING?