forum

Home / DeveloperSection / Forums / Add a zero to the returned value if there is no zero

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

Anonymous User 1848 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.

mssql server

Updated on 08-Jul-2013

I am a content writter !

Can you answer this question?

Answer

08-Jul-2013

Hi,

Try as following

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