Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mflammia
Starting Member
44 Posts |
 Posted - 2008-10-07 : 13:50:27
|
| Currently using a macro to fill forms using SQL. The query below does the job I require, but I need to include a carriage return between each addition to make the form fill more ledgible - is that possible using SQL?SELECT (_DETAILS + _PRICE + _TIMES +_CONTACT + _DIRECTIONS) from test.dbo._DATAMany thanks. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-07 : 13:56:12
|
| SELECT (_DETAILS + CHAR(13) + _PRICE + CHAR(13) +_TIMES +CHAR(13) +_CONTACT +CHAR(13) + _DIRECTIONS) from test.dbo._DATA |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Adding a carriage return within a Query?