website problem

[Edison]

i have this error when someone going to register " Syntax error converting the varchar value 'UnitedKingdom' to a column of data type int." how do i fix it?

[MentaL]

[KarLi]

go to sql query and runs this query

SELECT dbo.tblQuestionnaireNP.[id], FirstName + ' ' + LastName AS Name, CompanyName, CASE
WHEN Cast(Q2a As Varchar) = '0' THEN 'No'
WHEN Cast(Q2a As Varchar) = '1' THEN 'Yes'
ELSE CAST(Q2a AS VARCHAR)
END
AS Q2a
FROM dbo.tblQuestionnaireNP