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 |
Briefly describe your ideal job
Have you done summer training in HR then why do you want to go in marketing(after dual spesilisation in Marketing and HR)?
how will be the career growth in railways if we join as a asst. station master?
hai im sandhya i need sbi previous question papers with answers pls send to email : www.manoja79@gmail.com
what is meant by nearest specification limit in six sigma?
WHICH COUNTRY IS KNOWN AS "COCKPIT OF EUROPE"
what si the age limit for the voice
there is 1 flower in d basket on d 1st day & it doubles on each day if it get full on 9th day den on wat day it wil be half..? -Sravan
PLEASE SEND ME THE SBI CLERCIAL MODEL QUESTION PAPERS
What is SEO(Search Engine Optimization)?
how would you like to talk to a travel agent regarding hotel offers special rates
plz suggest some interview questions for upcoming interview of SBI PO 2 be held in feb.