SQLTeam.com | Weblogs | Forums

Trimming number by even location in a row


I would like to find a way to trim a set of numbers by even location in a row. For example: 36303032363038333031. The output should be like 6002608301


Cast as character then pull what you need. Cast the result back to the number format you wish.


I will try that, thanks


Hi djj55,

Thanks for your reply.

I'm a beginner in this.

Could you kindly provide an example.

I will try to grasp from there.

Thanking you in advance.


What is the criteria for the trim?

    @str    varchar(20) = '36303032363038333031',
    @p    int,
    @o    varchar(20)

    @p    = len(@str),
    @o    = ''
while    @p    >= 1
    select    @o = substring(@str, @p, 1) + @o
    select    @p = @p - 2
select    @o