🚀 go-pugleaf

What error do you have? Note that Name is special keyword and use:

Select [Name], ([City] + ', ' + [Country]) as [Location] from [tblIndy]

If City or Country is not string column, use

Select [Name], (CStr([City]) + ', ' + CStr([Country])) as [Location] from
[tblIndy]

If this does not help, install latest MDAC and Jet SP.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"Rainer Welzel" <rainer@fgg-welzel.de> �������/�������� � ��������
���������: news:3ea23628@newsgroups.borland.com...
> This doesn't works.
> I use Jet 4.0
> with a ADOQuery and a DBGrid.
>
> rainer
>
> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> schrieb im
Newsbeitrag
> news:3ea14f97@newsgroups.borland.com...
> > This depends on your DBMS. In MS SQL Server use (pubs db):
> >
> > Select (au_lname + ', ' + au_fname) as [name] from authors
> >
> > ----------------------------------------------------------------
> > Regards,
> > Viatcheslav V. Vassiliev
> > http://www.oledbdirect.com
> > The fastest way to access MS SQL Server, MS Jet (MS Access)
> > and Interbase (through OLEDB) databases.
> >
> > "Rainer Welzel" <rainer@fgg-welzel.de> �������/�������� � ��������
> > ���������: news:3ea14b69@newsgroups.borland.com...
> > > Hi ,
> > > I failed to combine 2 fields  with the following statement:
> > >
> > > ADOQueryIND->SQL->Add("SELECT Name, City & ', ' & Country AS Location
> FROM
> > > tblIndi");
> > >
> > > also
> > >
> > > ADOQueryIND->SQL->Add("SELECT Name, City || ', ' || Country AS
Location
> > FROM
> > > tblIndi");
> > >
> > > this statement failed.
> > >
> > > Have anybody the right syntax ??
> > >
> > > thx rainer
> > >
> > >
> > >
> >
> >
>
>