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

  1. UPDATE Pro_BIO SET RName = RTRIM(substring(RName, 0, PATINDEX('% %', RName)))

Report this snippet  

You need to login to post a comment.