title: Find and replace query in SQL server
body: <p>I want to change my name column records like if the name is with one word (Example: John) it should remain same (Ex: John). If it is with two words (Ex: John Bodi) it should be there as it is (Ex: John Bodi) but if it is one word and one letter (Ex:John B) then it should get '.' at the end of the letter(Ex: John B.)
  Please post your query for this. It helps me. </p>
  
  <p>Table is likes as</p>
  
  <pre><code> CREATE TABLE dbo.tblNames 
  (
      ID int,
      FName varchar(25),
      LName varchar(25)
  ) 
  GO
  
  INSERT INTO tblNames 
       VALUES (1, 'John', 'Bodi')
  INSERT INTO tblNames 
       VALUES (2, 'Jack', 'B')
  INSERT INTO tblNames 
       VALUES (3, 'S', 'Fry')
  INSERT INTO tblNames 
       VALUES (4, 'H', 'M')
  GO
  </code></pre>