DECLARE @Id Int                               
SELECT @Id = Id From sysobjects Where Name = 'PISReceivedPrescription'
IF Exists(SELECT * FROM syscolumns WHERE id = @Id and Name = 'MedicalRecordNumber')
Alter Table PISReceivedPrescription Alter Column MedicalRecordNumber  Varchar(50)


