Help with SQL concatenation Query 5

[dibblm]

select cfname + ' ' + (isnull(cmi , ' cmi ')) + '. ' + clname as expr1

This works and solves my null value issue I started with however I get periods on records that have no mi.

I would like to delete the fact of inserting a period if there is no MI.
example:

John A. Doe
Mary B.
Jane Doe (with no period for no MI)

 

[Norris68]

I've never actually used the SQL CASE statement before - I'll give it a go. Star to you.