Concatenate string in a stored procedures
Posted on 2006-06-28
I need to utilize a concatenate string in a stored procedure. I have a module in dnn (DotNetNuke) called Enterprise Forms. It allows me to utilize databinding within a field of a form. There is a field element option called ‘selectlist’. This allows me to have a drop down list with a series of options within in it. With the databinding feature I can have it reference a sql table for the options to be displayed in the ‘selectlist’ element. The only problem is that the table that I’m referencing has two columns that I need to display in the ‘selectlist’ element. The developer told me that I can use a concatenate stored procedure to display two columns in one display. If possible, someone please send me an example. The table is called 'Products'.