UPDATE	M	
	SET	path = REPLACE(path,'Debtors_','Medical_')
		,control = REPLACE(control,'debtors','medical')
--SELECT	*
FROM	pal_Module M
WHERE	path like 'Debtors_%'


IF NOT EXISTS(
    SELECT *
    FROM sys.columns 
    WHERE Name      = N'isSurfaceField'
      AND Object_ID = Object_ID(N'pal_Module'))
BEGIN
ALTER TABLE [dbo].[pal_Module]
    ADD [isSurfaceField] BIT NULL;
END
