Combine Names using function

Amudhan Kuppan

8y951SQL

anyone please help me

iam creating function to combine a FirstName LastName and Middle Name

mostly iam try but i have got one error please rectify it

i will send document

8 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palanivel8y ago
Accepted answer
Hi Amutha,

Try the below code,
SELECT CONCAT(@FirstName,' ',@LastName,' ',@MiddleName,' ',@Result)
Shahriar Nikkhah8y ago
i am going to assume you are doing this within a table, then why not use....
SELECT CONCAT([FirstName] , ' ' , [LastName] , ' ' , [MiddleName] )
FROM [YourTable]
SELECT  FullName = RTRIM(CONCAT (ISNULL([FirstName] + ' ', '') , ISNULL([MiddleName] + ' ', '') , ISNULL([LastName] + ' ', '') ))
    ,   *
FROM [dbo].[Client]
OR
SELECT CONCAT([FirstName] , ' ' , [LastName] , ' ' , [MiddleName] , ' ' , [Result] )
FROM [YourTable]
Amudhan Kuppan8y ago
hi ramesh
create function fn_titlecase(@str as varchar(1000))
returns varchar(1000)
as
begin
declare @bitval bit;
declare @result varchar(1000);
declare @i int;
declare @j char(1);
select @bitval = 1,
@i=1,
@result = '';
while (@i <= len(@str))
select @j= substring(@str,@i,1),
@result = @result + case when @bitval=1 then UPPER(@j) else LOWER(@j) end,
@bitval = case when @j like '[a-zA-Z]' then 0 else 1 end,
@i = @i +1
return @result
end
first this query will be executed
after iam using this function name
select dbo.fn_titlecase('raja')
second this single line statement will be executed after you get output is Raja
Amudhan Kuppan8y ago
thats also try it execute sucessfully
after iam use that function name in select dbo.combine_names(;nayan','modi','p')
this statement not execute
wait i will send one example please see
Ramesh Palanivel8y ago
then remove the select statement and try again.
Amudhan Kuppan8y ago
Ramesh select statement is not included in function statement so in this part select statement not need
Ramesh Palanivel8y ago
Hi Amuthan,

Please change your code,
SET @RESULT=SELECT CONCAT(@FirstName,' ',@LastName,' ',@MiddleName)
RETURN @RESULT;
Amudhan Kuppan8y ago
no change ramesh same error