Can an SQL stored procedure simply return its inputs, concatenated?

Question

To fit an edge case, I'd like to create a stored procedure (Access SQL!) which simply returns the concatenation of three inputs. So

MyProcedure('AAA','BBB','CCC')

returning

'AAA,BBB,CCC'

Obviously this is elementary in most programming languages, but I didn't know if SQL was capable of this at all.

Answer 1

You can do this with simple string concatenation. Check out this site for more information on how to do it with access (hint, use the & operator):

http://www.techonthenet.com/access/functions/string/concat.php

Answer 2

How about:

select @param1 + ',' + @param2 + ',' + @param3

(MSSQL syntax - similar)

Answer 3

One way to do this:

@Param1 + ',' + @Param2 + ',' + @Param3

Answer 4

A stored procedure would not be as flexible as a user defined function

Create Function dbo.udf_Concat (
 @String1 varchar(100) 
  , @String2 varchar(100) 
  , @String3 varchar(100) 
)
Returns varchar(300)
AS
Begin
Return (
 Select @String1 + @String2 + @String3
)
End

Then to use it in a query: Select dbo.udf_Concat('this', ' that', ' the other') as The_Three_Strings