Steve: It seems that you may need your application to do the capitalzation for you instead of SQL by checking words in a table and leaving those words alone and capitalize the rest. If you want to do it all in SQL then a loop (cursor like) that checks all the words in a table and compares them may be your only solution but that will take more resources.