I have just included a simple set that will upper case any letter that is proceeded by a non-letter with the exception of apostrophes. You can modify the WHERE clause to suite your personal rules for when to convert a character to upper case. Here is a version that uses a sequence or numbers table rather than a loop. Select dbo.fnConvert_TitleCase(upper('Whatever the mind of man can conceive and believe, it can achieve. RETURN calls: select dbo.fnConvert_TitleCase(Upper('ÄÄ ÖÖ ÜÜ ÉÉ ØØ ĈĈ ÆÆ')) as test I know this is late post in this thread but, worth looking. RETURN dbo.ToProperCase('ALL UPPER CASE and SOME lower ÄÄ ÖÖ ÜÜ ÉÉ ØØ ĈĈ ÆÆ')Īll Upper Case and Some lower Ää Öö Üü Éé Øø Cc Ææ ![]() white space definition can be configuredĬREATE FUNCTION VARCHAR(255)) RETURNS VARCHAR(255)ĭECLARE VARCHAR(10) - characters considered as white space. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |