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 Posted / 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 |
Post New Answer View All Answers
who is the first blind man riding to the mount everest.
Why you choose air force over navy and army?
who is our first indian test team captain. who is our first indian odi team captain.
Is there any method (like format and font type,font size) to prepare the documents in pharma or biotech companies?
Hi, I have passed the SBI SO written exam for the post Ass.Manager(Systems) . Could anyone help me with the interview type and questions? Thanks bjdas1987@gmail.com
Sir me s.I ke bare me janna chahta hoo.s.I banne ke liye kya kya common chahiye .mene is sal isc diya.
my parents resides in us and i have no reason to say why i will come back plz tell me what answer i will give as my interview is on 20 july
plz mail me the latest topics for discriptive papers or latest topics for bank clerical exams
I m employee can i describe my daily routine? I can but my daily routine is same all the day its so boring. Can anyone help me? Is there any topic to describe my routine. Thank You
IS ANYONE GOT OFFER LETTER WHO ATTENDED THE IBM (CMR COLLEGE) HYDERABAD INTERVIEW ON APR 12 & 13, 2012
am getting tired often and getting bored,distracted while doing or learning something....but am having high ambition and intention to do something big....how should i overcome my tiredness and stay focussed??
We want that when we type baishakh and drag the fill handle,Excel should produce jestha, Aashadh and so on.What will you have to set to do that ?
hi this is laxman. i did't find group 2 challan form on apspsc site plz help me , where it is?
i am B.E Civil engineer 2 year exp in construction i want to job in singapore so pls tell me any best and trust oversea consultancy in chennai plzs help me
When will the result of Bank of baroda clerical 2010 Intervu be declared?