Also be aware of the noise word list and how this affects the search results when searching for text containing common words.

I also agree that producing the sort of results...

UPPER(LEFT([State], 1)) + LOWER(SUBSTRING([State],2,LEN([State])))

Is one way of doing this, though it would be better to update your insert Stored Procs than use a trigger.