function for Upper case

[asuni]

Hi all,
I am using Access 2003 database.
Is there any function to select upper case of the data. I mean
SELECT UPPER(NAME) FROM TBLNAME;
Thanks

 

[gemma-the-husky]

what are you trying to do?

in things like this access is not normally case sensitive

 

[DCrake]

The normal syntax = UCase() or LCase()

 

[asuni]

ok i am new to MS Access, thanks i got it. i used UCase function.
Thanks
And one thing how to alter a column by using ALTER command. i mean i want to modify ( increase column length ) one column using alter command how?
Thanks

 

[DCrake]

If you want to permanently change the width of a field in a table you can onmly do this if you have exclusive access to the mdb. Are you sure you actually want to alter the size of the field? As this is normally only a one off exercise then why not do it manually.