Good morning. Good thought on the font. Fortunately, I reenter the value myself before I copy and paste that¹s when I discover problem data that doesn¹t jump right out. Nonetheless, after discovering a few bad values (thanks to Rowland¹s tip), I queried the suspect street_name records (360), reentered a good value and replaced the contents of the found set. All is good!
Peace, Steve On 7/20/09 6:34 PM, "richardsrussell tds.net" <[email protected]> wrote: > > > On Mon, Jul 20, 2009 at 4:21 PM, Steve Roethel <[email protected]> wrote: >> Rowland, you're right on! >> >> Although there were no visible characters or spaces in each questionable >> field, As I pasted fresh data in each record, the active sort adjusted the >> them in ascending order on the fly. Hmmm, that's something I wasn't aware of >> either. Sweet! > > One possibility occurred to me when I saw the word "paste". If you're not > entering the number yourself but are relying on what other people have typed, > you may be getting lower-case "L"s instead of "1"s or capital "O"s instead of > "0"s. Yes, even here in the 21st Century, some people cling to their old > typewriter habits. Using a font that provides a strong distinction between > these confusable characters (such as a VT font that runs a "/" thru the zero) > might help make the problems stand out in a crowd. >
