Prefix 0 in a Phone number string SQL


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for professional robotic engineers, hobbyists, researchers and students

declare @phone_nums as table(
  [phone_number] varchar(20)

insert into @phone_nums values  

update  @phone_nums set  [phone_number] = '0' + [phone_number]
   where  len([phone_number]) = 9

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results