UPPER Function in SQL

[VictoriaJones]

I want to change the data in a particular field from LOWER or PROPER case to UPPER. Whilst I know how to do this in Excel, I am at a loss as to how to convert/update this data in SQL!

Thank you!

 

[dalchri]

The function that you are after is the UCase function. For example:
[tt]
UPDATE YourTable
SET LastName=UCase(LastName)
[/tt]

 

[VictoriaJones]

Thanks for that, however, I am clearly doing something rather stupid!!

This is the code I have written, using your example:

UPDATE BCE_Functions_TEST SET fun_name=UCase(fun_name);

But I am getting an error message when I attempt to run this:

"Function isn't available in expression in query expression "UCase(fun_name)"."

Have I left something out - cant seem to see it myself.

Thanks
Victoria