SQL to convert to upper case
I need to convert a text in a field called "Bin" to upper case. I am using Access 20007 front-end and SQL 2005 backend. Example:
Table - Inventory, Bin=abc
After convertion:
Table - Inventory, Bin=ABC
Table - Inventory, Bin=abc
After convertion:
Table - Inventory, Bin=ABC
SELECT BIN = UCase(BIN)
FROM YourTableName
mx
FROM YourTableName
mx
Try:
SELECT UCase(BIN) as bin FROM Inventory
SELECT UCase(BIN) as bin FROM Inventory
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
UPDATE Table1 SET Table1.BIN= UCase([BIN]);
Make a backup first.
mx
Make a backup first.
mx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I used the Update Query because I want the changes saved. I used the Access version but it is good to know the SQL 2005 version. Thanks for all your help.
from yourtablename