The number assigned to an employee, customer, vendor or product for identification. Although it may contain only numeric digits, account numbers are often defined and stored as a character field, also known as a "string" or "alphanumeric field," so that parts of the number can be searched independently.
For example, if the first two digits in a customer number were a state code, and the next three were the city code, state and city could be easily searched. Take the case of searching for state code "44" and city code "111" on a 14-digit account number defined as the following three subfields:
If the field were defined as characters (a string), the query would be LOOK FOR "44111" IN CHARACTERS 1-5. If the field were defined as a numeric field, the entire number has to be taken into consideration, making it awkward. The query would have to be GREATER THAN 44110999999999 AND LESS THAN 44112000000000. See string.
For example, if the first two digits in a customer number were a state code, and the next three were the city code, state and city could be easily searched. Take the case of searching for state code "44" and city code "111" on a 14-digit account number defined as the following three subfields:
Subfield Positions in Field State Code 1-2 City Code 3-5 Customer # 6-14
If the field were defined as characters (a string), the query would be LOOK FOR "44111" IN CHARACTERS 1-5. If the field were defined as a numeric field, the entire number has to be taken into consideration, making it awkward. The query would have to be GREATER THAN 44110999999999 AND LESS THAN 44112000000000. See string.
 | Reproduced with permission from Computer Desktop Encyclopedia. Copyright (c) 1981-2009 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- Mailplane 2.1.1 (Mac)
- Acting as a site specific web browser for Google's Gmail, Mailplane is a full fledged Mail client for the Desktop. It fully integrates the Gmail web interface into the Mac experience, offering you the best of both worlds. And since Mailplane doesn't change the way Gmail works, its unique features...
- Software downloads 2009-11-27
- Double Entry Accounting 2.14 (Windows)
- By using the double entry accounting system a user can enter in up to twenty million journal entries to create any number of accounts, T-account ledgers, running balance ledgers, trial balances, income statements, and balance sheets in a simple but effective form. Accounting periods can be carried over. Also includes...
- Software downloads 2009-11-27
- ALMS 2.3 (Windows)
- ALMS -Auto Large Mail Sender is a professional high speed bulk e-mail sender program. It is an ideal for newsletters, targeted marketing, and keeping in touch with clients. You can use it to send Plain Text or HTML e-mail to your customers, friends or relatives, the number of addresses to...
- Software downloads 2009-11-26
- FreeMMS for iPhone 1.9 (Mobile)
- FreeMMS for iPhone lets you compose Unlimited FREE MMS messages. Send mms to your contacts or friends that use our supported carriers. It will take out the parenthesis and dashes for you, but you may need to remove a leading one from the number. Your MMS message will be sent...
- Software downloads 2009-11-25
- Microsoft tries toppling Google with a bribe
- Big CatchMySpace, Fox News, couple dozen newspapers, couple dozen magazines, other Fox channels, Sky.The major News Corp viewers will see that if they want to search, they'll Bing it.Even if people link News Corp content in Twitter or Blogs, Google can't go to those links and crawl the content on...
- Discussion threads 2009-11-23
- GrandCentral closing up shop
- The service Google snatched up in 2007 that lets users attach multiple phones to a single phone number is officially closing its doors on December 31st this year. An email went out to users of the service stating Google's intentions to close the doors on GrandCentral.com. ...
- Blog posts 2009-11-22
- Auto Mail Sender 4.0 (Windows)
- Auto Mail Sender AMS is used to send e-mails automatically at anytime and any frequency as you expect, it satisfies all your mailing requirements. You can set automatic sending time yearly, monthly (contains last day and serial number contains last of weekday), weekly, daily and specific date and time. AMS...
- Software downloads 2009-11-20
- Friday Challenge: What's your take on OS/browser market share trends?
- Firefox is taking over...With Firefox the days of vendor lock-in withIE required are over, like banking sites theyare cross-platform as they should be.I use CentOS/Fedora/RHEL and use I am able todo all of my job functions and use any applicationI want without the fear of security holes andthreats from a...
- Discussion threads 2009-11-13
- Eric Schmidt on whether Google is getting evil
- I Am A Victim of EvilHere is evil to me.I cannot stop Google from spamming me...or at least one of their Google Groups.A while back I bought an Ubuntu mini 9 from Dell.It was great.I loved it.It got stolen by some druggos while I was using it at Westlake plaza...
- Discussion threads 2009-11-12
- Account Xpress Lite 3.7.1 (Windows)
- Account Xpress Lite is a personal finance management and budget planning software loaded with features designed to help you manage your money quickly and easily. Track and reconcile transactions for virtually any kind of accounts (credit cards, savings, checking, cash). Budget management is made easy with the help of user-defined...
- Software downloads 2009-11-12
- KooLoader 1.6 (Windows)
- KooLoader is an all in one download manager software that guarantees a worthy Internet downloading experience through the addition of an adaptive download accelerator, segmented downloads for acceleration, an astounding number of simultaneous downloads. The program offers support for Internet Explorer, Firefox. Anytime you need to download something online, copying...
- Software downloads 2009-11-12
- MB First Vowel Numerology 1.0 (Windows)
- MB First Vowel Numerology Software is an extraordinary numerology tool that takes into account the first vowel in your name and finds the numerical value of the first vowel, does first vowel numerology analysis and tells you the influence of the first vowel on the different aspects of your professional...
- Software downloads 2009-11-11
- Enterprises saving $26 million per project with open source
- Using Only COCOMO Seriously FlawedIt assumes that every component would be developed from scratch for every project instead of being commercially licensed or re-used from another in-house project.A MySQL license purchased from Sun is much less expensive than recreating MySQL.Wow that's such total crap I'd be amazed if anyone believed...
- Discussion threads 2009-11-10
- MB Telephone Number Numerology 1.0 (Windows)
- MB Telephone Number Numerology Software does a free telephone number numerology analysis and tells you if the telephone number or the mobile number you are using is suitable for you or not. This wonderful numerology software for phone number numerology reading takes into account your numerical associations on the basis...
- Software downloads 2009-11-10
- Account Xpress 3.7.1 (Windows)
- Account Xpress is personal finance management and budget planning software loaded with features designed to help you manage your money easily and efficiently. Track and reconcile your transactions for virtually any kind of accounts. Budget management is made easy with the help of user-defined income and expense categories, budget projections,...
- Software downloads 2009-11-10
- MB Palmistry Ascendant 1.0 (Windows)
- MB Palmistry Ascendant software is a unique tool that is based on the blending of palmistry rules as well as Vedic astrology ascendant principles. This tool takes into account the number of horizontal lines on your little finger or mercury finger and finds out your ascendant sign. In addition to...
- Software downloads 2009-11-10
- Mac OS X mega patch covers 58 security vulnerabilities
- Yikes, that sounds bad[i]The majority of the flaws could allow a remote attacker to gain complete control of an unpatched system, meaning that this update carries an "extremely critical rating."[/i]Makes me glad I run an alternate OS.473MB?!?!?!How do dial up users get this update?There is a potential positive spin on...
- Discussion threads 2009-11-09
- Cisco unveils collaboration, e-mail and social tools for the enterprise
- ChoiceIt's exciting to see more choice coming to the market for cloud email. I see this marketing evolving like the telco market, where there will be a number of big providers (e.g., 5 or so) and then small regional / vertical vendors. It should be interesting to watch....
- Discussion threads 2009-11-09
- Twitter and web forgery
- Last evening as I was winding down after a long journey imagine my surprise when I started to receive a tsunami of @ replies on my Twitter account. Apparently I was direct messaging a stack of people I don't know with a link to something that...
- Blog posts 2009-11-05
- JPEE 5.4.2 (Mac)
- JPEE E-mail Utility is available as a free email extraction, filterer, verifier, exporter, manager, and emailer utility all in one economical application. Take the bulk out of your email! Features include: Complete Email Merge Solution Unlimited Custom Tag support Conditional Tag support Inline Image Attachments...
- Software downloads 2009-11-05
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- Keep Up With The Latest In Document Management with The DocuMentor.
-
Doc delivers the scoop on today's enterprise content management, printer maintenance, and all other issues related to document management. It's the DocuMentor Blog.
- Learn more >>
- Save time with automated shipping solutions
-
The Business Essentials Guide provides you useful tools and templates to help grow your business and save you time with automated shipping solutions.
- Visit the UPS Business Essentials Guide
- The more you simplify, the more you save
-
When you transition from your existing Red Hat environment to SUSE Linux Enterprise from Novell, you can recognize dramatic cost savings, perhaps as much 50%
- Learn more >>
- New Online Dashboard for IT Leaders
-
Read about top issues IT decision-makers face every day, plus get cost-effective solutions to real-life IT problems.
- Learn more >>
- Microsoft Dynamics CRM Online - Free Six-Month Trial for Eligible Organizations
-
Microsoft Dynamics CRM Online provides fast online access, simple contact management and better sales performance for a low monthly cost - the best value on the market today.
- Learn more about the free, six-month trial offer>>
-
-
Smart Tech
Expert advice on innovations in healthcare and the green technologies that make it happen.
Find out more
-
Smart Business
Discussion and advice on management issues that revolve around making your world smarter and more useful.
More Smart Advice
-
Smart People
The best and worst moves in the management and strategy trenches.
Learn More
