Change Name Format

The DB this info is pulled from stores the NAME field in all caps.
My query returns the name like= JAMES JONES
Is there something I can do to change the name format to James Jones?

SELECT
[OPEN CASES].CASE,
[OPEN CASES].[MEMBER#],
[CLIENT TABLE 2].NAME,
[CLIENT TABLE 2].A1,
[CLIENT TABLE 2].A2,
[CLIENT TABLE 2].ADD INTO [MEMBER CASE TABLE]

FROM [CLIENT TABLE 2] INNER JOIN [OPEN CASES] ON [CLIENT TABLE 2].MEMBER = [OPEN CASES].[MEMBER#]

WHERE ((([CLIENT TABLE 2].RELATION_CODE)="C")) OR
((([CLIENT TABLE 2].RELATION_CODE)="S") AND
([CLIENT TABLE 2].MEMBER_CASE_STATUS)="A"))

ORDER BY [CLIENT TABLE 2].ADD;