CAST(deptid AS decimal(6,0))>Can Cast() be used in a Where clause as in the following example? The deptid field is defined as char(6). When I execute the following nothing is returned but if I remove the where clause records are returned? What am I missing? Is there a better way to do this?