> > 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 Tue Jul 20 2004 - 19:44:46 CDT
