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
what is marketing, purchase and sale?
Describe a time when you anticipated potential problems and developed preventive measures
hi, igot previous years papers of out tech.and gen.from the website www.apsrtc.gov.in.as of 2009 papers are available in that website. if any got any more old question papers plz mail me to sowmyayedavilli@gmail.com plz do me the favour .....................................thankyou all
hi frnds ny idea ke sbi po ka result kb tak ayega?? plz join this thread n share imp n relevent information..
why i am suitable for national physical laboratory
who is the founder of inorganic chemistry
Why only sulphuric caid used in residue on ignition, not other acids.what is its special property
hi i m ashu , i am selectd in sbi interview 2010 plz guys suggest me how to prepare for that...........
i'm working as assistant manager in state bank of patiala. I want to join sbi.i have passed the written examination. In the wake of merger, would i be considered for selection, despite being from sbop
Hey Guys, can somebody suggest me how to consantrate on study because i m going to appear a tough competative exam and i m detuch with study about 4,5 years.It's not a multipal choose type exam. plzzzzzzzzzzzzzzzzz suggest me.
What are the seven wonders of this world?
I have an interview with capital iq for the post of research associates. Can anyone please help me with the type of questions that they can ask? Please, it's urgent. Thank you.
hi... my name is Rekha.... i selected karnataka bank wailisting list.... this is confirm of getting job in karnataka bank or not,,,,,,,,,, please reply my name comes in waiting list..........
hi i have been salected for interview of sbi clerk plz send me some questions that often asked in interview hall
A boy asked a girl her name then she told him that her name is 6,12,16,23,19,3 then what is her name?