Hi,

(thank you for not overquoting)

SELECT CAST(tblcountry.country || '/' || tblstate.state || '/' ||
tblcounty.county AS VARCHAR(value) )
AS location
FROM ...

Replace "value" with a value that can hold teh concatenation of the 3
columns.


With regards,

Martijn Tonies
Database Workbench - the developer tool for InterBase & Firebird
Upscene Productions
http://www.upscene.com

> Ah, I am trying to execute this sql in SQL editor itself. There
> itself i am facing the problem.
> > > > > SELECT tblcountry.country || '/' || tblstate.state
> || '/' ||
> > > > > tblcounty.county AS location ,tblcounty.countyid AS
> locid ,'1' AS
> > > > > name FROM tblcounty,tblstate,tblcountry WHERE
> > > tblcountry.countryid =
> > > > > tblstate.countryid AND tblcounty.stateid = tblstate.stateid
> AND
> > > > > countyid IN (SELECT tblcounty.countyid FROM
> tblcounty,tbltaxcounty
> > > > > WHERE tblcounty.countyid = tbltaxcounty.countyid AND
> > > > > tbltaxcounty.taxid=:taxno )