Why not use a computed column:

create table #t1

(

eno char(2)

,enoUpper as Upper(eno)

)

Buzz

select * from sys.tables

Buzz

From the expected results, it looks like you want to retain status changes and not delete duplicates

Buzz

From the expected results, it looks like you want to retain status changes and not delete duplicates

Buzz

select right('00' + cast(month(getdate()) as varchar), 2)

is a little shorter

MRB

For a once only export use SQL Server Import and Export Wizard:

Right Click on the Database then:

Tasks->

Export Data->

Next->

Data Source = PRINCE ->

Next->

Destination = Microsoft Excel; Excel File Path =...