alan

Try something like this

create table #SoftwareTest

(

SoftVersion varchar(500),

SoftVersionUpdated varchar(500)

)

insert into #SoftwareTest (SoftVersion)

Select '10.78.5'

union

Select '1.78'

union

Select '2'

union

Select '4.5'

union

Select '20.5'

union

Select '4'

union

Select '8.63.0'

union

Select '10'

union

Select '4.56.89'

update #SoftwareTest set SoftVersionUpdated=

case when CHARINDEX('.',SoftVersion,0) >0 then

substring(softversion,0, CHARINDEX('.',SoftVersion,0) )+ '.X'

else SoftVersion + '.X' end

select * from #SoftwareTest

drop table #SoftwareTest