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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-29 : 22:43:21
|
Nathan writes "Specifically, I need to know how to create an “Enter� character in a SQL query. In other words, what is the SQL language equivalent to ASP’s “vbcrlf?�
My real world example:
SELECT (‘Name:’ + Contact_Name + ‘Phone:’ + Contact_Phone)
AS [Contact Information]
FROM tbl_ Contact
What I would like to do is insert an “Enter� character between Contact_Name and Contact_Phone. If it were any other character or string I would do the following.
SELECT (‘Name:’ + Contact_Name + ‘XYZ’ + ‘Phone:’ + Contact_Phone)
AS [Contact Information]
FROM tbl_ Contact
" |
|
|
|
|
|
Inserting any ASCII character into a SQL query