Change text to all caps

[nyucknyucknyuck]

Using Expression Builder...

I have some state codes that have used lower case and upper case. How to I CHANGE everything to all upper case, not just make them APPEAR on screen that way.???

 

[PHV]

One way (SQL code):
UPDATE yourTable SET [state code] = UCase([state code])

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[nyucknyucknyuck]

Thanks! That worked!