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
Do IT ians welcome ECE students to software field?
1. I'm just S.S.L.C I don't have UG completion... But l want to study PG in M.Com or any fine arts in PG, Is it possible..., If possible please tell me which university can i apply,,, is that University in Chennai ?.
what is capital,finance in accountancy??????????
how to print the most continuously repeated character in a string?
what are the questions asked by interviewer for the post of logistics executive?
how to configure squirrel mail in rhel5???? guide step by step
The lowest common multiple of two different numbers is 24, and the greatest common factor is 12 what are the two numbers?
pls money is my problem now to help my family. tell others and give them my email pls
Tel me da fee structure of RACE?
Why only sulphuric caid used in residue on ignition, not other acids.what is its special property
I heard about online data entry job and is this job safe, legal to do at home. How I will find a good online job to do at home ?
if incentive is linked with the salary and we are paying Income Tax on that. can the incentive be held at any point of time by the employer?
how do they cal for SBI interview? based on merit or roll no?
WE HAVE 2 YEAR CONTRACT WITH VODAFONE FOR PROVIDING POSTPAID SERVICES TO OUR ORGANIZATION. THE FIRST BILL CAME FOR MONTH OF JAN 2010 OF AMOUNT Rs. 17695/- . I HAVE TO CALCULATE TDS ON THIS AMOUNT OR NOT ? IF, YES THEN MY QUESTION IS TDS IS MADE ON WHAT AMOUNT AND ON WHAT PERCENTAGE.
how to prepare for upcoming group-1 exams.what is the material is best suit for preparation of group-1.