Comparing SmallInt and VarChar?
Posted on 2006-03-26
Hi, I want to run the following query:
SELECT ShortName, InsurerID
WHERE InsurerID IN (
WHERE AttorneyID = @att)
ORDER BY ShortName
The problem is that InsurerID is datatype SmallInt and Description is datatype VarChar. These are neccessary differences, so changing the database is out of the question.
How can I cast one into the other to make this query work?