Re: A Normalization Question

• Post for FREE via your newsreader at post.usenet.com ****

"Neo" <neo55592_at_hotmail.com> wrote in message news:4b45d3ad.0407201644.25e3dfc5_at_posting.google.com...
> > > One can't derive that 'brown is composed of b, r, o, w, n' from an
> > > empty db; but a demo could convince me otherwise.
> >
> > SELECT "brown" AS [string], spell('brown') AS spelling;
> >
> > Function spell(s As String) As String
> > n = Len(s)
> > r = Left(s, 1)
> > For i = 2 To n
> > r = r + "," + Mid(s, i, 1)
> > Next
> > spell = r

> If the query is stored in the db, then info to spell 'brown' is coming
> from SQL stored in db.

The query is not stored in the db.

>If the query is not stored in db, the info to
> spell 'brown' is not coming from the db but from the string 'brown' in
> the SQL statement itself.

No, it is not.

>You derived that 'brown is composed of b, r,
> o, w, n' not from an empty db but from info within the SQL statement.

Have you seen any tables in the example ? The SQL statement could ask for the spelling of any string not just for 'brown'.
So the info is not coming from the SQL statement or from the string "brown". It is coming from the way strings and spelling are defined.

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=