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-2008 The Computer Language Company Inc. All rights reserved. |
Additional Resources
- Cool Tools - What is your Twitter grade?
- HubSpot has launched what it is calling the Twitter Grader, which seems to be the now-defunct Tweeterboard reincarnate -- yet with a proposed business purpose. The grader allows Twitter users to enter in their screen names and the names of others into its secret algorithmic stuff generator and find out...
- Blog posts 2008-08-29
- Inside India's CAPTCHA solving economy
- No CAPTCHA can survive a human that's receiving financial incentives for solving it, and with an army of low-waged human CAPTCHA solvers officially in the business of "data processing" while earning a mere $2 for solving a thousand CAPTCHA's, I'm already starting to see evidence of consolidation between India's major...
- Blog posts 2008-08-29
- Comcast sets 250GB ceiling
- Now, it's official. Comcast will impose a 250GB monthly cap on its Internet customers, as the SF Chronicle reports. Violators will get a notice and a warning. If you do it twice in a six-month period, they may terminate your account. What's more, Comcast...
- Blog posts 2008-08-29
- Microsoft patents 'Page Up' and 'Page Down'
- The software maker has been granted a US patent on "navigating paginated content in page-based increments." Microsoft has been granted a patent on 'Page Up' and 'Page Down' keystrokes. The software giant applied for the patent in 2005, and was granted it on August 19, 2008....
- News items 2008-08-29
- The depressing future of the Internet
- A brief overview of how the Internet came about: some years ago, some military boffs thought it'd be awesome if computers could talk to each other, so the US could nuke the hell out of other countries without actually being near there. A smart professor from England then came up...
- Blog posts 2008-08-28
- Comcast takes broadband cap plunge; Other carriers likely to follow
- Comcast will implement a 250 GB data monthly cap on customers starting Oct. 1. The move, reported first by DSL Reports, was confirmed by Comcast today Techmeme. On its site, Comcast posted its amended user policy: We've listened to feedback from our customers who asked that...
- Blog posts 2008-08-28
- Windows 7 pricing thoughts - Is Windows too expensive?
- Windows 7 pricing thoughts - Is Windows too expensive?It is an apt comparison>Your Ubunutu/Vista comparison doesn't pass the common sense test. Think about what you can get with Ubuntu-- Compiz Fusion for eye candy, drive encryption, MythTV DVR app, OpenOffice.org, ect. You have to get Ultimate Windows to get all...
- Discussion threads 2008-08-28
- Number of Internet users in Asian countries in April 2008
- Country April 2007 April 2008 Growth, % Asia Pacific 280,418 318,623 14 China 90,274 102,848 14 Japan 53,685 55,260 3 India 22,395 28,375 27 South Korea 26,323 25,652 -3 Australia 10,048 10,904 9 Taiwan 9,245 10,388...
- Blog posts 2008-08-28
- Why does Safari stink?
- Why does Safari stink?Safari on iPhone is even worseSafari on a Mac should work at least as well as Firefox. but on the iPhone it crashes regularly or locks up the iPhone. And it appears Apple's licensing is designed to preclude any competition:"Apple's software requirements for the device are too...
- Discussion threads 2008-08-28
- The importance of the Veoh decision
- The importance of the Veoh decisionThe problem is "appropriate steps".The question is, how thoroughly does a store-and-serve operation have to police what it's storing?In this case, removing something shown to be violating copyright on notification is sufficient. And that's reasonable.The problem is the situation when there are millions of...
- Discussion threads 2008-08-28
- IDC: 2Q Server units up; Price war looms; IBM keeps market share lead
- IDC: 2Q Server units up; Price war looms; IBM keeps market share leadWhat about number of units?Looks like these "market share" figures are based on revenue, right? Don't you have any info on units installed? A cheaper alternative will always show a lower revenue share; a free alternative will show...
- Discussion threads 2008-08-28
- SaaS market will 'collapse' in two years
- SaaS market will 'collapse' in two yearsHe doesn't get itSo to summarize Debes (who comes off a little like Vinny from da mob or a coke dealer - his words, not mine):(1) SaaS and Cloud computing as a delivery vehicle has been tried before and therefore will fail (like all...
- Discussion threads 2008-08-28
- Is probiotics a scam?
- Is probiotics a scam?Is probiotics a scam?Probiotics are not a scam but you do have to know what you are looking for. I was taking a digestive enzyme which had several probiotics in it including acidophilus. It worked fine for me. Will I recommend them to everyone? No...
- Discussion threads 2008-08-28
- Are gamers doping during tournaments?
- It's not typical Toybox fare, but it made me wonder just what kind of "toys" people are keeping in their toyboxes these days. A fascinating recent Gameplayer interview chronicles some tokin' and smokin' at the World Cyber Games in Germany, with the Tournament Director's full knowledge: ...
- Blog posts 2008-08-28
- Dell's second quarter: Another milepost in the turnaround tale
- Dell's second quarter: Another milepost in the turnaround taleSurprized - Dell is a garbage companyThat's all they make - GARBAGE....It'll be interesting to see how they can cut costs further as their quality is already below the bargain basement junk.OK, Larry, I have to askHow can something be "expected to...
- Discussion threads 2008-08-28
- GoBootstrap: simplifying SME accounting
- I'm keen to see startups in the accounting for small business space. Part of that is because I spent more years than I care to remember in finance roles, part is in the belief that accounting systems that reflect a 600 year old methodology are well...
- Blog posts 2008-08-28
- Hero of the week: Mike McDerment
- It's rare for me to pick out individuals but Mike McDerment CEO of FreshBooks deserves attention by anyone in the startup game and especially those trying to develop business applications. I first came across Mike some two years ago when FreshBooks had about 70,000 registrants. That number is now over...
- Blog posts 2008-08-28
- KidsMouse for Mac (sit)
- Education software suitable for infant learning with mouse operation. This software collects twelve kinds of learning games such as ABC Puzzle, The space recognition, paint, memory, number, color ball, easy puzzle, crayon, seesaw, number puzzle, shape puzzle, flowerpot, USA puzzle, and world map puzzle. All games can only be operated...
- Software downloads 2008-08-28
- Lucky Draw Ball (exe)
- Lucky Draw Ball is a fun and easy way to find a winner. The MSagent character will read out the winner name or number as it displays on the lucky draw ball. Enter all participants number or name in the settings, participants list, and one click to spin for winner....
- Software downloads 2008-08-28
- CNC Code Shooter Mill and Lathe (exe)
- CNC G-code generator for cnc mills and lathes in one program, choose a processor file, add G-codes and M-codes as needed, combined mill and lathe into one program, added G76, G92, radius, rapid, new set up sheet, face, groove, new tool, turn, bore, mic over balls, set x, y, and...
- Software downloads 2008-08-28
Neighboring Terms
Premier Vendor Content Whitepapers, webcasts & resources from our Power Center Sponsors
- Access the latest Intel and industry best practices
-
Designed specifically to address the concerns of senior IT managers at organizations with more than 100 employees, the Intel Premier IT Professional Program provides best practices via local and e-Seminars and a members-only Web site.
- View the Intel Premier IT Professional web-site tour >>
Ultraportables
- Understanding Ultraportable Laptops (BNET)
- Five steps to protect mobile devices anywhere, anytime (TechRepublic)
- View all ZDNet Toshiba laptop reviews
- From our sponsors
- Toshiba Satellite® U400 Series
-
- The ultra-portable, ultra-stylish Satellite® U405 is a smart choice for you and your small business. Only from the laptop expert, Toshiba. Explore the complete laptop lineup »
-
