how to print last character as to be in upper case and remainig characters has to be

[Harish Reddy]

i need to print last character in a word as upper case and remaining characters has to be in lower case
for example :
company is my word
i need to print it as companY

[Uncle Dickie]

Use a combination of the UPPER and LOWER functions e.g.

DECLARE	@text as varchar(5)
SET	@text = 'Hello'

SELECT	lower(left(@text,LEN(@text)-1)) + UPPER(RIGHT(@text,1))