SQL Server Performance Forum – Threads Archive
require a stored procedure
hi i have a doubt again i have a field test1 which takes normally a firstname lastname combination field like a greetingex: mr. harley davidson where in this case firstname is harley and lastname is davidson so this test1 filed is having data mr. harley davidson
and firstname lastname fields are empty and have to fill the firstname lastname fields using this test1 field where in this cases firstname and lastname are null values see the following examples and please send me the procedure to build the following procedure to update those breaked firstname and lastname from test1 field and to be updated in the firstname and lastname and test1 and data also to b present conditions like these example1 Dr.jane1austine
note:
‘1’ is a single blankspace
example2 Dr.1jane1 austine,jr EXAMPLE mr.r.waren1cookey
example mr.r. waren1cookey,III
example: mr.r.1waren1cookey,jr.
example: Dr. george1v.huffmon1III
example:Mr.1Bardley1E.Lackey
exampe:Mr.Fred1A.1wragnerIII
exampe:Mr.B.G.1Stogner
example:Mr.Allen1P.1Hunt,Jr
exampe:Mr1&1Mrs.1xyz
example:Atlantel,Inc.
sql server
This has been discussed recently.
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=14285
]]>