The "`" character has an interesting twist in my travels. Somehow, somewhere in the past, using an apostrophe to bound text in an English statement caused unpredictable results. The Quote (double quote if you're counting) character didn't have those problems.
Thus, I ceased using the single quote (apostrophe character) for anything except as a text value, not as a quotation bounding character. The "`" grave character is relegated as text only and in those systems that I see character stripping subroutines, it's removed along with the control characters. The premise was that the purpose of many text fields (as opposed to validated fields) is its LIKE-style lookup later. If the maint program removed them, then the lookups could strip their sought text and make their match. If the correct spelling of RESUME (re-su-may) has the grave character on the last E but it gets stripped, then it's RESUME (re-soom). Words like O'rielly retain their apostrophe though. While there is an increase in foreign character modifiers, aka umlauts, tildes, graves, in today's global communications, they present inconsistent results when searched for later. If the user doesn't include the grave in RESUME, it's a different word and meaning. On the other hand, the accepted spelling of many words with modifiers is without as well. Not many people know of using the <alt156> keystroke combination to add cuteness to their words. It's like typing an attribute mark. My 2 cents Mark Johnson ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[email protected]> Sent: Sunday, October 14, 2007 12:36 PM Subject: Re: [U2] select statement with single quotes > A grave is also a tic isn't it? > > Karl > > <quote who="Kevin King"> > > Glen pretty well made my point. The ` is a grave, not an apostrophe. > > Bill, > > I'm not sure what exactly you mean; technically the ' is the apostrophe > > AND > > also single quote. In fact, apostrophe is the proper name, single quote > > is > > merely convenient vernacular. > > ------- > > u2-users mailing list > > [email protected] > > To unsubscribe please visit http://listserver.u2ug.org/ > > > > > -- > Karl Pearson > Director of I.T. > ATS Industrial Supply, Inc. > [EMAIL PROTECTED] > http://www.atsindustrial.com > 800-789-9300 x29 > Local: 801-978-4429 > Fax: 801-972-3888 > > "To mess up your Linux PC, you have to really work at it; > to mess up a microsoft PC you just have to work on it." > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
