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


Please Help Members By Posting Answers For Below Questions

tell me question of ssb??

1434


List and discuss with examples the 4 principles of Scientific Management

1412


hi i have appeared my personnel interview for sbi clerical post on 6th may.. i am waiting for the final result.. can you tell me when will the final result..

1460


Tel me da fee structure of RACE?

2100


I have an experience of 6yrs in non voice bpo sector. M bbm graduate. I feel it is not an long term secure job, here v can stay maximum 35-40 with maximum salary of 25 to 30k.. my question is what is next.. what after 40yrs..? Plz suggest me for my future step... do u guys want me to sstay with it.. or want me to step another industry.. if yes.. what are the options..?

1382






Hi friends I am sasi,Got selected for Syndicate Bank PO.I dont have any idea about Banking sector.I dont know how to prepare for the interview.Can anyone help me plz

1655


How can i talk by using Pc/Laptop to our frnds? please tell the steps in details.

1379


We a One DHCP Server in org with 500 users if my DHCP is down and somehow it can`t be repaired within 2 days what the alternative rather than static IP?

1652


what is the difference between file base architecture and web based architecture in datastage?

1483


i want to do ncfm certification course in kanpur plz. provide information

1466


If OS crash that how to get outlook backup?

1452


how to prepare for exam for the post of DIPLOMA TRAINEE at HAL and also i want previous question papers.please send me.

1909


why dont you join your family business????

3742


how can you identified yourself?

1399


did anyone attended java 2+ exp interview in dec-2010?

1373