How can I concatenate a String with a Bit (documentTitle+Archive) SQL server 2005 -


When I try to insert an operand type collision, I get the following error: Incompatible bit data type with text Invalid operator for: Add operator equal, write equal bit

  SELECT F.SubmissionId, F.FormId, F.DocumentTitle + F.Archive AS DocumentTitle, F.Keywords, F.PublishDate, F .PostedDate, F.ExpiredDate, F.Isflag, F.ISAdmin Only, F.IS, F. Has been published, f. Prepared Date, F. Article Comment, Case When F. Archive = 1 then join the form as 'yes' and 'no' in the form of the end, I.ItemId, I.SubmissionId AS Expr1, I.ParamId, I.ParamValue FROM dbo.app_FormSubmission F INNER as dbo.app_FormSubmissionI I need to convert F.SubmissionId = I.SubmissionId  

To see it run I

  declare @i bit select @i = 1 Select 'abc' + Convert (varchar (1), @ i) - Select 'ABC' @ @ - - Failed  

Comments