Add a zero to the returned value if there is no zero

Anonymous User 2173 08 Jul 2013

The following query returns the following sample data from my db.

select mobileno

from Person

sample results:

775623655

0758956556

0756899955

777325656

How can I add a 0 in front if there is no 0 in the returned values?

Thanks in advance.

AVADHESH PATEL 08 Jul 2013

Hi,

Try as following

SELECT CASE LEFT(mobileno,1) 
    WHEN '0' THEN mobileno
    ELSE '0' + mobileno
    end
FROM Person

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

forum