sql force line/string break

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
Who is Participating?
pssandhuConnect With a Mentor Commented:
Incser this where ever you need to add a break line:
CHAR(13) + CHAR(10)
Hopefully that should do it.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.