Hi,

I have the foolowing select statement in my query;

Code:
SELECT        '-- Please Select --' AS PhysicianID, 0 AS OrderCol1, 0 AS OrderCol2
UNION ALL
SELECT        PhysicianID, PracNo, PhysicianID AS Expr1
FROM            TblPhysicianInfo
WHERE        (CONVERT(nvarchar(50), PracNo) = @cmbPracID)
ORDER BY OrderCol1, OrderCol2
PhysicianID is an INT Data type in the database..

I receive the error message;

Code:
Conversion failed when converting the varchar value '-- Please Select -- ' to data type int
How can I go round this?

Thanks