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 completed my btech in 5years..can i get job on java..do recruiters prefer me if i get a good command on java
sir/madam, i would like to know the work for fresh engineering electrical graduates in psu,ies etc.,
if a material tested by titration and finish test by HPLC we can prepare working standard by which method.
what is marketing, purchase and sale?
I forgot my E-mail ID Password. So, anyone send me the date for clerical interview for SBI.My Email id is dhanssmailbox@gmail.com
What is the importans of colums in Accession register?
Brief me about plug and play technology?
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, igot previous years papers of out tech.and gen.from the website www.apsrtc.gov.in.as of 2009 papers are available in that website. if any got any more old question papers plz mail me to sowmyayedavilli@gmail.com plz do me the favour .....................................thankyou all
I know the ip address of a website(for example ip address of www.yahoo.com is 69.147.125.65). How can i use this ip address to open the website instead of typing the url www.yahoo.com in the browser.
Hiiiiiii i m sakshi;i m selected in BOB clerk written test.My interview will be on 11th Oct but there is a problem that i entered marks of my 10th class in HSC column of qualifications in my online application though i also have above 80% marks in my 12th class. I m very much stressed ......they wil cancel my candidature??????? plz help me...........what should i do?
We a One DHCP Server in org with 500 users if my DHCP is down and somehow it can`t be repaired within 2 days what the alternative rather than static IP?
my all friend got the date of exam why should i not
I received a phone call about my verizon yahoo account. The message that was left I did not understand. Could you please tell me what is going to change with my yahoo account. It was something about switching to webmail. It said to go to verizon.com/test. That did not help me. Please responed because it said they are swithing on the 27th of April.
I have done MBA(Finance & Mktng) back in 2009 and then join the BPO backend process for 1 year and done sap sd and now i m lkking for the sap sd or mba job ..please reply fast at lalit.chitkara@gmail.com if you have any suggestion...i need job immediatly...