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
tell me question of ssb??
List and discuss with examples the 4 principles of Scientific Management
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..
Tel me da fee structure of RACE?
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..?
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
How can i talk by using Pc/Laptop to our frnds? please tell the steps in details.
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?
what is the difference between file base architecture and web based architecture in datastage?
i want to do ncfm certification course in kanpur plz. provide information
If OS crash that how to get outlook backup?
how to prepare for exam for the post of DIPLOMA TRAINEE at HAL and also i want previous question papers.please send me.
why dont you join your family business????
how can you identified yourself?
did anyone attended java 2+ exp interview in dec-2010?