SQL: Connecting Strings of a Group

#21

Hi Gene,

Quote:

Is there a way in SQL to concatenate strings from different rows
into a list?
What I have understood about SQL your boss's wish is beyond the intention of SQL.

With "big" SQL-Systems like DB2 you could define your own aggregation function
(like sum()) to do this. But within Foxpro the easiest (may be only) way is the
use of xBase commands.

Regards
Bernhard Sander

#22

Hi Gene,

Quote:

Is there a way in SQL to concatenate strings from different rows
into a list?
What I have understood about SQL your boss's wish is beyond the intention of SQL.

With "big" SQL-Systems like DB2 you could define your own aggregation function
(like sum()) to do this. But within Foxpro the easiest (may be only) way is the
use of xBase commands.

Regards
Bernhard Sander

#23

Hi Gene,

Quote:

Is there a way in SQL to concatenate strings from different rows
into a list?
What I have understood about SQL your boss's wish is beyond the intention of SQL.

With "big" SQL-Systems like DB2 you could define your own aggregation function
(like sum()) to do this. But within Foxpro the easiest (may be only) way is the
use of xBase commands.

Regards
Bernhard Sander

#24

Hi Gene,

Quote:

Is there a way in SQL to concatenate strings from different rows
into a list?
What I have understood about SQL your boss's wish is beyond the intention of SQL.

With "big" SQL-Systems like DB2 you could define your own aggregation function
(like sum()) to do this. But within Foxpro the easiest (may be only) way is the
use of xBase commands.

Regards
Bernhard Sander

#25

Hi Gene,

Quote:

Is there a way in SQL to concatenate strings from different rows
into a list?
What I have understood about SQL your boss's wish is beyond the intention of SQL.

With "big" SQL-Systems like DB2 you could define your own aggregation function
(like sum()) to do this. But within Foxpro the easiest (may be only) way is the
use of xBase commands.

Regards
Bernhard Sander

#26

Hi Gene,

Quote:

Is there a way in SQL to concatenate strings from different rows
into a list?
What I have understood about SQL your boss's wish is beyond the intention of SQL.

With "big" SQL-Systems like DB2 you could define your own aggregation function
(like sum()) to do this. But within Foxpro the easiest (may be only) way is the
use of xBase commands.

Regards
Bernhard Sander

#27

Hi Gene,

Quote:

Is there a way in SQL to concatenate strings from different rows
into a list?
What I have understood about SQL your boss's wish is beyond the intention of SQL.

With "big" SQL-Systems like DB2 you could define your own aggregation function
(like sum()) to do this. But within Foxpro the easiest (may be only) way is the
use of xBase commands.

Regards
Bernhard Sander

#28

Hi Gene,

Quote:

Is there a way in SQL to concatenate strings from different rows
into a list?
What I have understood about SQL your boss's wish is beyond the intention of SQL.

With "big" SQL-Systems like DB2 you could define your own aggregation function
(like sum()) to do this. But within Foxpro the easiest (may be only) way is the
use of xBase commands.

Regards
Bernhard Sander

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SQL: Connecting Strings of a Group

comp.databases.xbase.fox comp.databases.xbase.fox

Re: SQL: Connecting Strings of a Group - 01-15-2008 , 02:47 AM

Re: SQL: Connecting Strings of a Group - 01-15-2008 , 02:47 AM

Re: SQL: Connecting Strings of a Group - 01-15-2008 , 02:47 AM

Re: SQL: Connecting Strings of a Group - 01-15-2008 , 02:47 AM

Re: SQL: Connecting Strings of a Group - 01-15-2008 , 02:47 AM

Re: SQL: Connecting Strings of a Group - 01-15-2008 , 02:47 AM

Re: SQL: Connecting Strings of a Group - 01-15-2008 , 02:47 AM

Re: SQL: Connecting Strings of a Group - 01-15-2008 , 02:47 AM