How to make a trigger that would filter data by type, one capital, the rest lowercase (Capital)?

Question

C++ / C#

Hello. How to make a T-sql or MS SQL trigger to filter data when entering.
an example is "VASYA" => "Vasya", no matter how you enter it, it will always be "Vasya"
Table dbo.Person here are my fields

In mysql I did like this (fields name, lastname, surname).

Answer 1

And what for for such trigger?
Normal variant - transformation on insert and update.
The ideal is in the form of a call to a stored procedure that writes preprocessed data.
Well, a moment: there is a famous literary character Jim DiGriz - he really doesn’t like the mockery of his last name)