SQL SERVER FUNTION

Question

Dear San, I want to write function so that it accepts string and character and returns modified string. for example if i send input as function_Name (asp.net,c#,sql Server, "OR") function must return "asp.net" OR "c#" OR "sql server" Thanks in advance

Raja T · Answer

Hello Samanta, Try like create FUNCTION [dbo].[fn_test1] (@var1 nvarchar(15), @var2 nvarchar(15) ) RETURNS varchar(30) AS BEGIN declare @Return varchar(30) select @return =REPLACE(@var1,',','"'+@var2+'"') return '"'+@return+'"' end Check out like SELECT dbo.fn_test1('test,test1,test2','or') AS res Results: "test"or"test1"or"test"

samanta · Answer

It is really very helpful to me. Thanks for your support.

Raja T · Answer

Hello Samanta, Try like CREATE FUNCTION [dbo].[fn_test] (@var1 nvarchar(15), @var2 nvarchar(15), @var3 nvarchar(15), @var nvarchar(15) ) RETURNS varchar(30) AS BEGIN declare @Return varchar(30) select @return ='"'+@var1+'"'+''+@var+''+'"'+@var2+'"'+''+@var+''+'"'+@var3+'"' return @return end Check out like SELECT dbo.fn_test('test','test1','test2','or') AS Results Results: "test"or"test1"or"test2"

Raja T · Answer

Hello Samanta, You are most welcome..

Raja T · Answer

If my answer is helpful to you. Kindly Accept the answer. Thanks

samanta · Answer

Sorry I need to pass the input as function_Name ("asp.net,c#,sql Server", "OR")

Upendra Pratap Shahi · Answer

CREATE FUNCTION [dbo] . [fn_SeperateString] ( @Tvar1 nvarchar ( 50 ), @Tvar2 nvarchar ( 50 ), @Tvar3 nvarchar ( 50 ), @seperator nvarchar ( 50 ) ) RETURNS varchar ( 200 ) AS BEGIN declare @Return varchar ( 200 ) select @return = '"' + @Tvar1 + '"' + '' + @seperator + '' + '"' + @Tvar2 + '"' + '' + @seperator + '' + '"' + @Tvar3 + '"' return @return end Check this- SELECT dbo . [fn_SeperateString] ( 'asp.net' , 'c#' , 'sql Server' , 'OR' ) AS Results OutPut- "asp.net"OR"c#"OR"sql Server"

samanta · Answer

Dear Raja-San, "asp.net,c#,sql Server" is a single string.

samanta · Answer

Dea rSan, I am not aware of functions so can you please give the sql code?

Upendra Pratap Shahi · Answer

Write sql function for this and replace comma by or and surrounded filter in double course and return this final object.

Gantasala Venkatanarayanamurth · Answer

string s = "Asp.net,C#,Sql"; Console.WriteLine(s.Replace(",", " or ")); Console.ReadLine(); then you get the desired output....