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 |
WHO IS RESPONSIBLE FOR COLLECTING THE SERVICE TAX
different between windos2000 server &2003 server?
why do you want to be cabin crew
bakit po lalaking seahorse ang nagdadala ng baby seahorse
Tell me about a time when you had to work as part of a team and someone was not holding up their end of the work (it can be work or school). What did you do?
Why did you choose this aviation carrer
I want sylabs of cleark test of H A U HISAR
hi i m laxmi pandit inm in waiting list of karnataka bank.anyone tell me what is it mean.is it surity of selection.they provide me last date 31 march 2013.help me i m confuse
what do you see yourself five years from now?
i had a 3 round interview with emerson one week back. After the last round i.e., the HR round the HR person told dat she will call me in couple of days. i did nbot receive any response from her. So, i sent a mail to her but not receive any reponse. Then after 2 days I called her den she told me that my profile is on hold. What does that mean?
i have my interview on 25th august of PNB. plz guide me for the same. i really need help! my id is sweet_neha1991@yahoo.com and blossoms.sana@gmail.com
What is meant by a repo loan and what is the relationship between banks and the FED given the bailouts?