updating text field from integer field conversion

[wish24bone]

Hi all, I have 2 tables, on the 1 table, I have a field I need updated from another field in another table.. so tbl1.field1 needs to be tbl2.field2 both are text fields.

The problem I'm faced with is that my criteria is the following..

tbl1.field1=tbl2.field1 tbl2.field1 is a number field not text. Here is my update query that is failing


UPDATE [exception] set [exception].[assigned to] =
(select [UserInfo].[Name]
FROM [UserInfo]
where [exception].[Assigned to] = cstr([userinfo].[id]))
WHERE [exception].[Assigned to] IN (SELECT cstr([userinfo].[id]) FROM [UserInfo]);


ideas?