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
hello freinds, i have done M.C.A this year. can anybody tells me what is the diffrence between on role and off role jobs in a telecome company & what is the salary diff. of these roles. are software companies also hire employees on onrole & off role ???????????/
what is the number of biodiversity in india
what are your major limitation
i had an backlog in my engg finial year.so i am counted as 2008 or 2009 passout for applying to IT companies? so what should i keep it in my resume thanks in advance.
This question is from administrator of Allinterview.com. OPnce you don't have answer to any silly question, why you ugly fellows, push your leg everywhere.
i want thanx my brother so i need nice wording
when ct ratio 50/5, 100/5,400/5 and 800/5 va:15,class:1 ilv:3 kv/-50hz sf<5 how to calculate kwh
enumerate various costs associated with the performance, security, support, and maintenance of ubuntu
what is the diffreence between sales insurance and other marketing ?
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?
Dear sir, Please tell me a rate analysis of single repitation of slab shuttering if we use only one time of shuttering material & use steel plat.
what are the things to be looked after for marketing,purchase and sale?
I'm a engineering graduate with 78%(first class with distinction).I've been selected in campus but i cant pay the deposit they asked.I cant afford staying in city and get a suitable job.I've been selected for sbi clerk exam.If he ask me,why r u coming for a clerk post, what should be my answer? Help me to find a suitable answer
Hey I am working as Trackman in Railways with Basic of 7610 and I have been selected as a clerk in one of Nationalised bank. Should I continue with the Railways or I should joing Bank as clerk?
Deloitte KPMG PwC and Ernst & Young – Big 4 Interview Questions 1. What accomplishment are you most proud of?