zero filling

[mickpiper]

example of the dataGR1972.267/3069 I need to zero fill after the first period so the data looks like Gr1972.0267/3069. Can anyone help me

[ck9663]

example of the dataGR1972.267/3069 I need to zero fill after the first period so the data looks like Gr1972.0267/3069. Can anyone help me

try


declare @stringvar as varchar(15)

set @stringvar = 'GR1972.267/3069'

select substring(@stringvar,1,patindex('%.%',@stringvar)) + '0' +substring(@stringvar,patindex('%.%',@stringvar)+1 ,len(@stringvar))