Last letter in a field capital

[dvannoy]

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

 

[tlbroadbent]

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