Re: A Normalization Question

> > 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. 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. You derived that 'brown is composed of b, r, o, w, n' not from an empty db but from info within the SQL statement. Received on Wed Jul 21 2004 - 02:44:46 CEST