Last letter in a field capital
Last letter in a field capital
(OP)
I need to make the last letter in my text field capital...The number of letters in the field will not always be the same??....I just need the last letter to be capital...
Any ideas??
Thanks
Any ideas??
Thanks
RE: Last letter in a field capital
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: http://members.home.net/tlbroadbent/sqlarticles.htm