Hello, I am new to SQL Server and I have a question. I am trying to develop a VB 2005 application that has a combobox with all of the possible termination codes. I would like the combo box to display:
"code" - "description"
(the code, then a hyphen, then the description of the code)
I have one table that contains only two columns, the code, and then the description.
I am envisioning a view, that concat's the two, but I am getting an error message.
Example:
SELECT stu_leave_code +' - '+ code_desc
FROM student_leave_codes
error: The data types nchar and text are incompatible in the add operator.
Any help will be appreciated.
"code" - "description"
(the code, then a hyphen, then the description of the code)
I have one table that contains only two columns, the code, and then the description.
I am envisioning a view, that concat's the two, but I am getting an error message.
Example:
SELECT stu_leave_code +' - '+ code_desc
FROM student_leave_codes
error: The data types nchar and text are incompatible in the add operator.
Any help will be appreciated.