How to find the last zero

Question

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply

Anam Verma SSCertifiable Points: 5365 More actions · Answer 1

sanuj (9/4/2008)
7.0.23.0. I want to update the last 0 with 4 using substring. How to do ?:hehe:

could be a better way to do it but this thing just triggered in my mind

select '7.0.23.0'

, reverse(substring(reverse('7.0.23.0'), charindex('0',reverse('7.0.23.0')) + 1, len('7.0.23.0'))) + '4'

btw what does this "7.0.23.3" denotes. Is it an IP address?