Formatted Query Result?

[limester]

Hi,
I am trying to return a formatted query result. For example:
SELECT * FROM TBL1
This will give me a string of text that I would like to format with carriage returns and semi colons.

Any help is greatly appreciated!

 

[SajidAttar]

Hi,

you can concatenate the fields and use char(13) for carriage return . .

if you are looking for something else, post some sample data and required output.

Regards,


"There are no secrets to success. It is the result of preparation, hard work, and learning from failure." -- Colin Powell

 

[limester]

Sorry I should have been more specific. The query results
would end up directly in a VB text box. The column in the
database will have just text (varchar(255)). For example i
use the query SELECT * FROM tbl1 WHERE column1 ='value' I
get:
The quick brown fox runs over the lazy dog
I would like to format it as:

The quick: brown fox
runs over: the lazy dog

Hope this clarifies it a bit.

Thanks!