John Fitgerald Kennedy
Kennedy, John Fitzgerald
Martin Luther King, Jr.
Jr., Martin Luther King,
create function [dbo].[TransformName] ( @inputText varchar(max) ) returns varchar(max) as begin declare @result varchar(max) ,@pos int select @pos = len(@inputText) - charindex(' ', reverse(@inputText), 1) + 2 ,@result = substring(@inputText, @pos, 8000) + ', ' + substring(@inputText, 1, @pos-2) return @result end
ScrewTurn Wiki version 3.0.1.400. Some of the icons created by FamFamFam. Except where noted, all contents Copyright © 1999-2024, Patrick Jasinski.