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

Anonymous User 2080 08 Jul 2013

Hi Developers!

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.

Anonymous User

Other

I am a content writter !

AVADHESH PATEL 08 Jul 2013

Hi,

Try as following

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

forum