advanced code snippet search

Posted By

hobeau on 04/23/09


Tagged


Versions (?)

replace multiple words at the first space

 / Published in: SQL
 

replace multiple words such as firstname + lastname

Expand | Embed | Plain Text 
  1. UPDATE Pro_BIO SET RName = RTRIM(substring(RName, 0, PATINDEX('% %', RName)))

Report this snippet  

You need to login to post a comment.