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


Please Help Members By Posting Answers For Below Questions

who is the first blind man riding to the mount everest.

1425


Why you choose air force over navy and army?

1468


who is our first indian test team captain. who is our first indian odi team captain.

1601


Is there any method (like format and font type,font size) to prepare the documents in pharma or biotech companies?

1227


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

1842






Sir me s.I ke bare me janna chahta hoo.s.I banne ke liye kya kya common chahiye .mene is sal isc diya.

1316


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

1456


plz mail me the latest topics for discriptive papers or latest topics for bank clerical exams

1371


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

977


IS ANYONE GOT OFFER LETTER WHO ATTENDED THE IBM (CMR COLLEGE) HYDERABAD INTERVIEW ON APR 12 & 13, 2012

2166


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??

1374


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 ?

2932


hi this is laxman. i did't find group 2 challan form on apspsc site plz help me , where it is?

1503


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

1280


When will the result of Bank of baroda clerical 2010 Intervu be declared?

1591