Replace first occurrence of '.' in sql String
Use STUFF
function
Find the first occurance of .
using CHARINDEX
and remove it using STUFF
SELECT STUFF(valuesT, CHARINDEX('.', valuesT), 1, '')
FROM TableT
Use STUFF
function
Find the first occurance of .
using CHARINDEX
and remove it using STUFF
SELECT STUFF(valuesT, CHARINDEX('.', valuesT), 1, '')
FROM TableT