advanced code snippet search

Posted By

myke on 07/31/10


Tagged

tap sbx


Versions (?)

Who likes this?

1 person have marked this snippet as a favorite

Tyster


Insert line break SQL

 / Published in: SQL
 

insert line break via sql query

Expand | Embed | Plain Text 
  1. UPDATE tableName
  2.  
  3. SET Description = 'New Description: blah blah' + CHAR(13)+CHAR(10) + CHAR(13)+CHAR(10) + 'Next line blah.' + CHAR(13)+CHAR(10) + CHAR(13)+CHAR(10) +  '<strong>Strong bottom.</strong>'
  4.  
  5. WHERE ProductID = 'nosoupforyou12'

Report this snippet  

You need to login to post a comment.