Eg:

Select (Emp.Title||''||Emp.Name) as EmpName, sum(Amount) from Emp
Group By (Emp.Title||''||Emp.Name) as EmpName

Above is my Paradox SQL Query and I only get the message that capability
not supported (where as the same works smoothly with SQL Server 2000).

( Same message even if i change it to:

Select (Emp.Title||''||Emp.Name), sum(Amount) from Emp
Group By (Emp.Title||''||Emp.Name)

)

Has any one come across this situation? I would appreciate some
suggestions on getting this to work

Thanx in advance,
Shafeeq.
--
Direct access to this group with http://web2news.com
http://web2news.com/?comp.databases.paradox

I see the exact same post in paradox-discussions, crossposting is not a
good idea.

- Veronica

Shafeeq wrote:

Hi
Im sorry about the cross posting,
but I still couldnt locate any such article. Would you mind pointing me
to that one. Guess there is some solution to that behaviour.

Thnx
Shafeeq.

Veronica Loell wrote:
--
Direct access to this group with http://web2news.com
http://web2news.com/?comp.databases.paradox

It was you that posted in paradox-discussion as well? I was trying to
point out that posting in two forums generally is not helpful for either
you or the people that try to answer your questions.

Shafeeq wrote:

Three forums if you include the BDE newsgroup.

"Veronica Loell" <lista (AT) nakawe (DOT) se> wrote