MS Query

  • Thread starter Thread starter Gary
  • Start date Start date
G

Gary

First, does someone know of a document that provides
details on MS Query functions and their syntax. For
example, I know I can use left, right, etc. What other
functions exist? I want to do some parsing on some data
fields and need to determine the length of the field and
the place where certain characters are located within
that field. Thanks.
 
Hi

ODBC query syntax is determined by driver, not by Excel. Usually it's like
the syntax, used in database system, from where you get data. P.e. the
syntax for FoxPro/VisualFox ODBC query is much like to syntax, you use with
queries in FoxPro/VisualFox - you only can't use UNION and [NOT] IN (SELECT
....) in ODBC query.
 
Arvi,
Thanks for the response. I am using Excel/MS Query to
get data from SQL Server database. Are you saying that
the Syntax for statements on SQL Server should work?
 
Hi

I think it's highly probably - why not simply to try it ! As I haven't any
experience with (MSSQL ?), I can't help you in this.

In previous posting I referred to FoxPro and VisualFox ODBC drivers, which
do have almost full FoxPro functionality. Now an example from worse side -
ODBC driver for Excel tables supports only 4 functions - MIN(), MAX(), SUM()
and COUNT(). And you can't use in WHERE, ORDER BY, etc. clauses columns, not
included into result table.
 
Back
Top