UPDATE AxProject
   SET prjID = SUBSTRING(prjDescription, 1, CHARINDEX(' ', prjDescription,1) -1)
 WHERE prjID LIKE '% %' AND prjKey = prjProject AND prjKey > 2 AND prjKey <= '208'

UPDATE AxProject SET prjID = substring(prjID from 0 for char_length(prjID ) -1 ) || '.' || substring(prjID from '..$') ;