How to detect non-number character in MySQL?

Question

I am creating a function that contains the following loop:

    While v_start >= v_stop do
    set v_msg := concat(v_msg,v_start,v_delimiter);
    set v_start := v_start + v_step;
    end while;

When I call the function, I pass the following parameter:

    select a06_counter_loop(10,-5, -3, '-->') as 'The Loop Output';

It should return:

    10-->7-->4-->1-->-2-->-5

But it returned:

    10-->7-->4-->1-->-2-->-5-->

My question is that how do I get rid of the last non-number character?

Let me know if you need the entire code for the function.

Thanks, Perri

juergen d · Accepted Answer · 2014-02-16 20:24:37Z

1

    set v_msg := v_start;
    set v_start := v_start + v_step;
    While v_start >= v_stop do
       set v_msg := concat(v_msg,v_delimiter, v_start);
       set v_start := v_start + v_step;
    end while;

answered Feb 16, 2014 at 20:24

juergen d

205k40 gold badges305 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

M Khalid Junaid · Accepted Answer · 2014-02-16 20:24:23Z

1

Try this by using CONCAT_WS(separator,str1,str2,...)

While v_start >= v_stop do
set v_msg := CONCAT_WS(v_delimiter,v_msg,v_start);
set v_start := v_start + v_step;
end while;

Demo

answered Feb 16, 2014 at 20:24

M Khalid Junaid

64.6k10 gold badges93 silver badges120 bronze badges

1 Comment

PMa Over a year ago

Thanks, but I cannot change the order of the parameters getting passed.

Collectives™ on Stack Overflow

How to detect non-number character in MySQL?

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related