Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Upper case

Author  Topic 

ilimax
Posting Yak Master

164 Posts

Posted - 2004-02-26 : 10:58:25
Can anybody help me? Why dis query does not work in Access?

UPDATE Table1 SET Column1 = UPPER(Column1);

ehorn
Master Smack Fu Yak Hacker

1632 Posts

Posted - 2004-02-26 : 11:20:34
I believe the function for access is UCASE:
UPDATE Table1 SET Table1.[column1] = UCase([Table1]![column1]);
Go to Top of Page

ilimax
Posting Yak Master

164 Posts

Posted - 2004-02-27 : 13:56:08
It is!

Thank you very much!

Go to Top of Page
   

- Advertisement -