Unanswered: Concatenate two fields with - between the values.
Good day all,
I have a field in a table which i'm trying to update to using two values from two seperate fields from the same table but adding a dash (-) inbetween the values, so the end result should look something like this Value1-Value2.
The Code i'm using is as below:-
set Field03= Field01 + "-" + Field02
where Field03 is null
but using this I get the error message "Invalid column name '-'."
Can anyone point me in the right direction? I can't quite figure this out.
Thanks for the tip, i'll bear that in mind.
I find I am using SQL server (2000 ed) more these days as I move more of the work away from my familiar ground of Access to SQL so the help I get from here is greatly appreciated.