Welcome to the DR Network.

Everything you need to get started building reports with Data Repository. All free and available for every MEDITECH version from MAGIC to Expanse. Sign up today!

Contact us

Parse Name (function)

  • MT platform: Client/Server, MAGIC, 6.0

This scalar TSQL function returns the user-specified portion of a patient's name from expressions with data in "LAST,FIRST MI..." format. Options include first name, last name, middle initial, title and suffix.

(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 parse mt name