You could use
SELECT SUBSTRING(Name,1,1) + '. ' +
SUBSTRING(Name, CHARINDEX(' ', Name) + 1, LEN(Name) - CHARINDEX(' ', Name))
You may run into problems with middle names.
At our site we store the name on the database in it's component parts i.e. firstName, MiddleNames, lastName which would make this task easier
Ok - have also just found the following links ..
http://www.sql-server-helper.com/tips/split-name.aspx[
^] which expands on my solution above
and
http://www.sqlservercentral.com/Forums/Topic943562-338-1.aspx#bm944589[
^]