SELECT  'Name: ', (CASE WHEN middle != '' THEN (initcap(lastname)||', '||initcap(firstname)||' '||initcap(substr(middle,1,0))||'.') ELSE (initcap(lastname)||', '||initcap(firstname)||' ')END)
FROM    customers
WHERE   lastname = '&vLN';