Combine Names using function

Question

hi 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

Ramesh Palanivel · Answer

Hi Amutha, Try the below code, SELECT CONCAT(@FirstName, ' ' ,@LastName, ' ' ,@MiddleName, ' ' ,@Result)

Shahriar Nikkhah · Answer

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 Kuppan · Answer

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 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 Kuppan · Answer

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 Palanivel · Answer

then remove the select statement and try again.

Amudhan Kuppan · Answer

Ramesh select statement is not included in function statement so in this part select statement not need

Ramesh Palanivel · Answer

Hi Amuthan, Please change your code, SET @RESULT= SELECT CONCAT(@FirstName, ' ' ,@LastName, ' ' ,@MiddleName) RETURN @RESULT;

Amudhan Kuppan · Answer

no change ramesh same error