Search code examples
ms-accessms-officecapitalize

Capitalize Just the last Letter in string - MS Access

I have a column in my access database table, I ran a query to make it proper case by using StrConv([MyColumn],3) but last two letters are state names and this query makes SOmeThing, soMethINg, NY to Something, Something, Ny, I want the result as Something, Something, NY Is there a another query I can run after to capitalize last letter?

Solution

  • You can use:

    UcaseLast: Left([YourColumn], Len([YourColumn]) - 1) & UCase(Right([YourColumn], 1))