1. Categories >> Everything Else >> Everything Else AllOther
  2. Suggest New Category

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

Question Posted / mercy


Hi, I need to create a user defined function to perform a sanity check on an alphanumeric f..

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

Post New Answer

More Everything Else AllOther Interview Questions

Can you balance rural urban divide in education?

0 Answers  

Why was Paul Simon in trouble when he was down in the schoolyard with Julio?

0 Answers  

Malawi has been facing a number of disasters ranging from floods, drought, strong winds and others. What kind of crops research organisations can help in the finding out of the best crops to plant in these scenario for the rural farmers to follow.

0 Answers   Focus, Focus Softnet,

what is the difference between funds flow and cash flow. define debt to service coverage ratio?

1 Answers   Karvy,

what is cross selling skill? how to answer ti this question

0 Answers   BirlaSoft,




can any one help me ,i'm appearing syndicate bank clerical exam on 27-6-10

0 Answers  

which type of questions are asked in interview related to warehousing profile. if anybody can support in this regard pls let us know?

0 Answers  

how to get c & f agengy licence or ragistration ??

0 Answers  

hi i have selected corporation bank and they ask to come for medical what are medical test they will do if there is nay problem and what type of test they will be taken

0 Answers  

i have worked at paper industry in instrumentation dept as asst.engg for two years in bank interview they asked me why u are coming to the banking field. what concrete reason i can give for this

0 Answers  

According to a novel by Alexander Dumas, how do we know Edmond Dantes better?

0 Answers   NPL,

why the the name "MOGHAL" adopted as name of the dynasty?

1 Answers  

For more Everything Else AllOther Interview Questions Click Here
Categories