Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Last letter in a field capital
- Thread starter dvannoy
- Start date
tlbroadbent
MIS
I assume you speak of a field or column in a table. Do you want to update the field or just display it on a form or report?
To display...
Select Left(TxtCol,len(TxtCol)-1) & ucase(right(TxtCol,1)) As NewCol From tbl
To update...
Update tbl set TxtCol = Left(TxtCol,len(TxtCol)-1) & ucase(right(TxtCol,1))
Terry
;-) USER, n.: The word computer professionals use when they mean "idiot." -Dave Barry
SQL Article links:
To display...
Select Left(TxtCol,len(TxtCol)-1) & ucase(right(TxtCol,1)) As NewCol From tbl
To update...
Update tbl set TxtCol = Left(TxtCol,len(TxtCol)-1) & ucase(right(TxtCol,1))
Terry
;-) USER, n.: The word computer professionals use when they mean "idiot." -Dave Barry
SQL Article links:
- Status
Similar threads
- Locked
- Question