fnMFCapitalizeFirstLetter¶

Signature¶

dbo.fnMFCapitalizeFirstLetter(
    @String VARCHAR(250)
)

Returns¶

String with the first letter of each word capitalized.

Parameters¶

@String VARCHAR(250) (required) - Input text to capitalize the first letter of each word.

Purpose¶

Capitalize the first letter of each word in the provided string.

Examples¶

SELECT dbo.fnMFCapitalizeFirstLetter('m-files connector')       AS Result;  -- M-Files Connector
SELECT dbo.fnMFCapitalizeFirstLetter('john DOE')                AS Result;  -- John Doe
SELECT dbo.fnMFCapitalizeFirstLetter('  multiple   spaces  ')  AS Result;  -- Multiple Spaces

Changelog¶

Date	Author	Description
2019-08-30	JC	Added documentation
2014-09-13	DEV2	Initial Version - QA