Return characters 
Author Message
 Return characters
Does anyone know hoe to put  a return character in a
concatenated filed?

Thanks



Mon, 15 Aug 2005 22:48:42 GMT
 Return characters

Are you referring to stored procedure return values? Please provide clear
details of what you are trying to do. If you are referring to Dynamic SQL &
trying to find how to return values, then you can refer to:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q262499

--
- Anith
(Please respond only to newsgroups)



Mon, 15 Aug 2005 22:52:57 GMT
 Return characters
SELECT 'line 1'+CHAR(13)+CHAR(10)+'line 2'

--
Aaron Bertrand, SQL Server MVP
http://www.aspfaq.com/

Please reply in the newsgroups, but if you absolutely
must reply via e-mail, please take out the TRASH.


Quote:
> Does anyone know hoe to put  a return character in a
> concatenated filed?

> Thanks



Mon, 15 Aug 2005 22:58:19 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. End-of-file or Return character in SQL?

2. Remove Return Characters in Varchar Vield?

3. Text data type - return character

4. carriage return character in SQL...?

5. limiting number of returned characters in a column

6. How to convert carriage return character to space?

7. I need a function that return character

8. Locating carriage return characters in LVCHAR field

9. Locating Carriage Return Character In String

10. Inserting RETURN character

11. Approach memo field return character question

12. How to return character string > 8000 in stored procedure?


 
Powered by phpBB® Forum Software