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.
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]); |
 |
|
ilimax
Posting Yak Master
164 Posts |
Posted - 2004-02-27 : 13:56:08
|
It is!Thank you very much! |
 |
|
|
|
|