I have the following query.
select site + '-' + Cast (DisplayID as varchar(11)) + ' - Notification on' + Cast(ContactOnTime as time) as CTime
I get the following error.
Msg 402, Level 16, State 1, Line 1 The data types varchar and time are incompatible in the add operator.
Is their way around this issue or this a limitation of SQL?
Any assistance is appreciated.