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 |
hi friends,im doing masters in us and in a short span of time i will get a job,my husband who is a designer completed his degree working in a MNC can come to us on dependent visa?please answer me.....
The ration of stone,sand and cement in a concrete mixture is 6;3;1.If you have 20m^3 of concrete,what is the volume of;sand,stone and cement?
have anybody receive the appointment order from iob pls reply me
1 Answers Indian Overseas Bank,
can u provide me dvc old model question paper for jnr. clerk-typist exam
We (a Private Organisation)have purchased furniture worth Rs.1.4 lacs from a firm Whhile making payment should we deduct TDS@2% ?
how recession in america is affecting our economy?
Can a Trust be made nominee in a life insurance policy
what should be replied in an interview when question is 'why u prefer to come in the job of marketing'
Internet site would you like the most?
hi does any one know about " MULTI LABS INDIA " company which was located in banglore wtc....i got job offer there..i just want to know about the company guys please tell me
Chain Ki Saans Punchline of Which Co.
How do you determine and evaluate success?