How extract the numbers only in SQL
-
How extract the numbers only in the particular filed (Mobile_no). ex. data’s like mr law ( 011-2231183) House Fax:72336 6553 En Zaiadnal -202323204 I used replace but still the characters is coming raj
Well, one solution would be to create table with a column (tinyint) named HouseFax in which you would place the number 72336 6553. You wouldn't have any problem extracting the number then... Pictures of the menu available at the drive-thru
-
Well, one solution would be to create table with a column (tinyint) named HouseFax in which you would place the number 72336 6553. You wouldn't have any problem extracting the number then... Pictures of the menu available at the drive-thru
-
How extract the numbers only in the particular filed (Mobile_no). ex. data’s like mr law ( 011-2231183) House Fax:72336 6553 En Zaiadnal -202323204 I used replace but still the characters is coming raj
You could soemthing like this, not very clever but it works and you could alway put it in an UDF. declare @Mob varchar(50) set @Mob = '0122-1230-123' set @Mob = REPLACE( @Mob , '-', '') set @Mob = REPLACE( @Mob , ' ', '') set @Mob = REPLACE( @Mob , '/', '') set @Mob = REPLACE( @Mob , 'T', '') set @Mob = REPLACE( @Mob , '\', '') SELECT @Mob Results -------- 01221230123 Look where you want to go not where you don't want to crash. Bikers Bible