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
- 1 Answers
- 4233 Views
- BNP Paribas, I also Faced
- E-Mail Answers
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 |
what do you mean by ARIDITY 1-TEMPORARY CONDITION OF WATER SCARCITY 2-PERMANENT CONDITION OF WATER SCARCITY
Q. WHICH IS THE HEAVIEST INTERNAL ORGAN IN THE HUMAN BODY?
How is it that I do not receive email from a regular sender on the first or second attempts but do on the third with no change in the subject or text.
What is Auto format in Excel?
what is the difference between structure and a class
how to calculate sensex and nifty.sensex contains 30 companies and nifty 50.so how is sensex value more than nifty
Can any one solve this one?? **A server configuration is controlled from a single web page with multiple options: 20 drop-down menus, with 3-4 options each. 5 check-boxes. 1 multi-select menu, with 5 options. 1 template selection, with 6 options: A, B, C, D, E, F. o When options A, B, C, D are selected, all options (#1-#3) above are available. o When options E, F are selected, only 10 out of 20 drop-down menus have an effect. Besides item #4, developers input is that all options are independent, I.e., not impacting each other. What is the required number of test configurations required in order to test the server configuration and release in good quality: Assuming first release. Assuming regression tests for release with new features not impacted by the above options. Test configuration is a complete set of options that were selected to be tested in one complete server configuration scenario. I.e, a test configuration is set of 17 or 27 specific options tested together.
please do tell me who the editor-in-chief of the Asian Age is as of 2011-12
what are the detail steps to be a professional golfer
How we configure release in SAP MM ?
pls explain difference between user exit and customer exit. how to create user exit and how to create customer exit? pls explain in detail.
THE VIVEK EXPRESS TRAVERSING THE LONGEST ROUTE IN INDIAN RAILWAY NETWORK RUNS BETWEEN KANYAKUMARI AND AT WHICH CITY?
Energy Oil Gas 
