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 |
wat r the standard books for the preperation in the view of Group1 exams held by APPSC
0 Answers State Bank Of India SBI,
Mention the major produce of West Indies
is crop loan waiver is a right approach to help farmers?
How to get a high quality game mouse
PS4 and Xbox One, which one is more suitable for multiplayer?
how do we calculate water consumption for brick work , plaster,land scaping and emergency for new commercial project
what is the process delete account on it site?
Hi, i have been selected for abhyudaya clerk interview but dont have the application print out. Will i be allowed for interview?
Whether the college conduct certificate can be produced as character certificate for bank interviews?
1 Answers Banking, State Bank Of India SBI,
i cleared the sept IBPS, and have applied for the interviews..please guide me on what type of questions might be asked by the panel...what dress code should i follow?
what is net salary increase for bank employees/officers , can they live with dignity with this salary
0 Answers State Bank Of India SBI,
I have only four months exp in banking field.. but i am searching for a better job.. in interview they are asking, what is the reason for changing the job so soon. the reason is to get high pay.. but if i tell like that.. they will not select me..so i want the best answer for this.. i am keep on searching for a better job.. so please me.. right now i am getting 6000rupees in HDFC BANK.. but i am expecting above 9000rupees.. so please help me to get a good job with a good pay..