Tupacmoche
Registered User.
- Local time
- Today, 08:10
- Joined
- Apr 28, 2008
- Messages
- 291
Hi All,
I have a simple update script that inserts a varchar(25) into an empty column. Its type is varchar(25) but the output table displays it in scientific notation which I think would be a number type. In any event here is the script how do, I get it to update as a string of number without the scientific notation?
USE Temp_Upload_Tables
Update tmpEpic_Name SET MRN2 = [Target Patient MRN]
FROM [dbo].MRN as m
inner join tmpEpic_Name as e
on m.[Source Patient MRN] = e.MRN
I have a simple update script that inserts a varchar(25) into an empty column. Its type is varchar(25) but the output table displays it in scientific notation which I think would be a number type. In any event here is the script how do, I get it to update as a string of number without the scientific notation?
USE Temp_Upload_Tables
Update tmpEpic_Name SET MRN2 = [Target Patient MRN]
FROM [dbo].MRN as m
inner join tmpEpic_Name as e
on m.[Source Patient MRN] = e.MRN