MSSQL - Convert to uppercase

Databases
1

I am naive enough to think this may work?

UPDATE tablename SET columnname = upper(columnname)

2

of course you are

and where would you be without those of us who hang out on database forums with nothing better to do than write simple little test scripts for people? :wink:

create table danmorgan ( txt varchar(14) )
;
insert into danmorgan values ('foo'),('bar')
;
select * from danmorgan

txt
foo
bar

update danmorgan set txt = upper(txt)
;
select * from danmorgan

txt
FOO
BAR
3

Wow! I wrote a query which worked first time!

Thanks Rudy!