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 |
1.Briefly describe your ideal job?
what are your weakness?
We (a Private Organisation)have purchased furniture worth Rs.1.4 lacs from a firm Whhile making payment should we deduct TDS@2% ?
how does telecom sector work ?
0 Answers Baidu, Reliance, Uninor,
I am looking for NIC Test Papers for the post of scientific officer If someone have Please send me at ashishgauba1985@yahoo.co.in
How we configure release in SAP MM ?
IC Chips which computer use is made from?
I need daily base metal prices in India (historical prices too) viz., Al, Cu, Zn etc.,
Hi friends, did any one has recieved joining letter from karnataka bank for the position of clerk. contact me @ cvimach@yahoo.com, Regards_ soumyakanta
................... GENERAL KNOWLEDGE Q. THE USE OF WHAT IN CARS HAS BEEN BANNED IN JUDGEMENT BY SUPREME COURT OF INDIA IN APRIL,2012?
What is System Restore?
3 FRIENDS GOES TO WATCH SHOP TO BUY WATCH THE SHOPKEEPER SAYS THE WATCH IS OF 60RS EACH ONE CONTRIBUTES 20RS THEN THE SHOP OWNER SAYS THAT WATCH IS OF 50 RS SO THAT SHOPKEEPER GIVES EACH PERSON 2RS AND KEEP 4RS TO HIMSELF NOW THE WATCH IS OF 18RS PER HEAD SO ITS EQUAL TO 56 BUT 18*3 = 54 SO WHERE IS THE 2RS