How to replace a period with a blank space? - SQL Server ...
SELECT REPLACE (@foo, '.', ' ') If you want to replace only the first Period. DECLARE @foo VARCHAR (255) SET @foo = 'I.am.foo!'. SELECT STUFF (@foo, CHARINDEX ('.', @foo), 1, ' ') Just be warned that if there isn't a period in the string you'll get a null. Charlie.
DA: 2 PA: 87 MOZ Rank: 56