Replacing leading characters in string

Question

How would i replace first two characters if they are zeros?

Example:

 1. 00001
 2. 00123
 3. 02451

Should be:

 1. 11001
 2. 11123
 3. 02451

EDIT: Forgot to mention i need this in select clause (in a view) Thanx.

Answer 1

update  YourTable
set     col1 = '11' + substring(col1, 3, len(col1)-2)
where   col1 like '00%'

In a view, you could do it like:

select   case
         when col1 like '00%' then stuff(col1, 1, 2, '11')
         else col1
         end
from     YourTable;

Live example at SQL Fiddle.

Answer 2

declare @a varchar(10)

select @a='01123'

Select case when LEFT(@a,2)='00' then STUFF(@a,1,2,'11') else @a end