Syntax error converting the varchar value

[ikim2000]

When I execute the statement below, I get an error "Syntax error converting the varchar value 'Air4Wire "

SELECT ID + CompanyName as Company from tblCustomer

The ID column is integer type and CompanyName is char type, and Air4Wire is a company name.



Thanks,
Ik

 

[Guest_imported]

First cast the integer field to a Char or VarChar datatype. i.e. Cast(ID as VarChar(16))