replace multiple words at the first space - SQL Snipplr Social Repository

Revision: 13451

at April 23, 2009 18:58 by hobeau

Initial Code

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

Initial URL

Initial Description

replace multiple words such as firstname + lastname

Initial Title

replace multiple words at the first space

Initial Tags

Initial Language

SQL