SQL SERVER FUNTION

samanta

10y3k

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

11 Replies

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

Raja T10y ago
Accepted 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"

+1
Raja T10y ago
Hello Samanta, You are most welcome..
0
samanta10y ago
It is really very helpful to me.

Thanks for your support.
+1
Raja T10y ago
If my answer is helpful to you. Kindly Accept the answer. Thanks
0
samanta10y ago
Sorry I need to pass the input as function_Name ("asp.net,c#,sql Server", "OR")
0
Upendra Pratap Shahi10y ago
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"
0
samanta10y ago
Dear Raja-San,

"asp.net,c#,sql Server" is a single string.
0
samanta10y ago
Dea rSan,

I am not aware of functions so can you please give the sql code?
0
Raja T10y ago
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"

+1
Upendra Pratap Shahi10y ago
Write sql function for this and replace comma by or and surrounded filter in double course and return this final object.
0
Gantasala Venkatanarayanamurth10y ago
string s = "Asp.net,C#,Sql";
Console.WriteLine(s.Replace(",", " or "));
Console.ReadLine();

then you get the desired output....
0