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
I have completed mba, i'm so much intrested in group2, can u plz tel me how to prepare for this exactly.
Hi,I have got selected as a clerk in Bank of baroda. I would like to know the career growth(promptions). Pls help me out.
Is there any method (like format and font type,font size) to prepare the documents in pharma or biotech companies?
valuation of share is it base of the company reputation
What is Aggressive behavior needed in corporate world? how aggressive play a role on of the Employee?
Sir, I am selected as a scale 1 officer in a pvt sector bank. What would be my responsibilities in the job??
What is induction cooker useable stainless steel
i'm working as assistant manager in state bank of patiala. I want to join sbi.i have passed the written examination. In the wake of merger, would i be considered for selection, despite being from sbop
i need general english by rs agarwal, link please
WHAT IS THE SALARY(GROSS AND TOTAL) OF A BRANCH MANAGER IN SBI IN BANGALORE?
mention some of the major contribution made by you in present & previous jobs- Sales Representative
hat will be the syllabus of The Descriptive paper of Forthcoming Bank of India P.Os Exam? I Have the copy of advertisement but there is no information in it that what will be asked in Descriptive Paper?
Difference between form of a word and its function.
do any one faced sbi interview. If yes please share ur experience
Where can I get good social advice?