Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Concatenate fields in SQL ?
Message
From
22/03/2002 13:16:10
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Concatenate fields in SQL ?
Miscellaneous
Thread ID:
00636165
Message ID:
00636165
Views:
50
Is there any way to concatenate character fields from several records in a SQL statement ?
Emp    Date        Note
---------------------------
1     {1/1/1}      Project 1
1     {1/2/1}      Assist Kim
2     {1/1/1}      Sick
2     {1/2/1}      Project 3

results desired:

Emp   Notes
---------------------------
1     Project 1 chr(13) Assist Kim chr(13)
2     Sick chr(13) Project 3 chr(13)
TIA
Bill Morris
Next
Reply
Map
View

Click here to load this message in the networking platform