USE [EnVisage]
GO
IF NOT EXISTS(SELECT * FROM sys.columns
WHERE Name = N'jobcode' AND Object_ID = Object_ID(N'Expenditure'))
BEGIN
ALTER table [dbo].[Expenditure] Add [jobcode] [nvarchar](25) NULL
end
go