Solved

sql force line/string break

Posted on 2009-07-14
1
379 Views
Last Modified: 2012-05-07
I have a string returing as the following - problme is that my gridview cell will not wrap it because it picks up the "Insertion/Replacement/Conversion" as one long unbroken string - the below is an example - not all will have "/? - som just might be really long medical terms - if there a way - in TSQL - after so many chars, etc. to force a break?

Insertion/Replacement/Conversion of a permanent dual chamber pacemaker
0
Comment
Question by:tbaseflug
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 17

Accepted Solution

by:
pssandhu earned 500 total points
ID: 24852536
Incser this where ever you need to add a break line:
CHAR(13) + CHAR(10)
Hopefully that should do it.
P.
0

Featured Post

On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question