🚀 go-pugleaf

If you have MS Office, look  jetsql40.chm. It should be somewhere on your
hard drive. For example, at

c:\Program Files\Common Files\Microsoft Shared\Office10\1033\jetsql40.chm

If you need substr() or other function - look MSDN. Jet uses the same
function as VB (but not all of them). For your case InStr can help.

Regards,
Vassiliev V.V.
http://www.oledbdirect.com
Returns the position of the first occurrence of one string within another.

InStr([start, ]string1, string2[, compare])
Arguments
  start
  Optional. Numeric expression that sets the starting position for each
search. If omitted, search begins at the first character position. If start
contains Null, an error occurs. The start argument is required if compare is
specified.
  string1
  Required. String expression being searched.
  string2
  Required. String expression searched for.
  compare
  Optional. Numeric value indicating the kind of comparison to use when
evaluating substrings. See Settings section for values. If omitted, a binary
comparison is performed.
Settings
The compare argument can have the following values:

      Constant Value Description
      vbBinaryCompare 0 Perform a binary comparison.
      vbTextCompare 1 Perform a textual comparison.

Return Values
The InStr function returns the following values:

      If InStr returns
      string1 is zero-length 0
      string1 is Null Null
      string2 is zero-length start
      string2 is Null Null
      string2 is not found 0
      string2 is found within string1 Position at which match is found
      start > Len(string2) 0



"Joachim" <mfgjojo@gmx.de> �������/�������� � �������� ���������:
news:3d4796b4$2_1@dnews...
> Hi NG,
> Where can I get a complete Reference of Microsoft Jet SQL?
>
> Thanks,
> Joachim
>
>