If you went to replace all periods with a space thenDECLARE @foo VARCHAR(255)SET @foo = 'I.am.a.string'SELECT @fooSELECT REPLACE(@foo, '.', ' ')
If you want to replace only the first PeriodDECLARE @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 nullCharlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION