phone icon 781.329.4300  ¦  Message us  ¦ Customer support login ¦ Product documentation

  1. You are here:  
  2. Home
  3. DR Network
  4. TSQL code
  5. Proper Case (function)

Welcome to the DR Network.

The DR Network has everything you need to get started building reports with Data Repository, including T-SQL stored procedures and functions, SSRS report definition files, and even Report Designer reports. Everything is free to the MT community and available for every MT version from MAGIC to Expanse. Sign up today!
Contact us
500 characters left

Proper Case (function)

TSQL code
  • MT platform: Client/Server, MAGIC, 6.0

This scalar TSQL function converts any text string to proper case (mixed case with initial upper case letter followed by lower case letters). Typically used to convert patient, provider, insurance names, etc. as stored in MEDITECH to a more user-friendly format.

(Read our blog for more information about user-defined functions in T-SQL.)

Please note: the image below is only a partial view of the complete function. Download the file to see the complete code sample.

To download this report, please log in or create an account. → 

fn proper case