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



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

without administrator right how to run iis services

0 Answers   V Angelz Technologies, Wonder Products,


when will the icse 2011 result proclaimed?

0 Answers  


Which is the best 3g internet plan for unlimited downloads with a speed of 3.1 mbps and after usage of data given for a month we get 256kbps .haryana state plans prefered

0 Answers   Reliance,


What are advantages and disadvantages of Nuclear power?

0 Answers  


hi friends hey i need a help. i m doin my 6thsem(B.E) i need to do a project on opengl(graphics). so can u please suggest me some good topics for my project.M NOT GETTIN ANY IDEA OF WAT TO DO. PLEASE INFORM ME as soon as possible. it shud be simple and innovative.

0 Answers  






1.Briefly describe your ideal job?

0 Answers   British Airways,


I am Umi, my question is I am very low confident person in my life all time m think m not suitable for this job or work, n my English also not good enough for backend n HR profile jobs that's why still I have job less n I am disappointed my self.

1 Answers  


how do we calculate sensex

1 Answers  


being a science how can u help a bank if we give u a job in a bank

0 Answers   State Bank Of India SBI,


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  


what process model is the best for on line shopping?.. v-model waterfall or spiral?

0 Answers  


I have selected in UBI PO and Waiting for SBI PO result. Right now I m Development Officer in LIC(recently recruited). Can anybody tell me what is the last salary and post i can get starting from a P.O.? Pls tell on urgent basis of mail me at chetanya.sharma@yahoo.co.in

0 Answers  


Categories