Tejas Patel pateltejasmca

Total experience of 4.5 Years in Development.

pateltejasmca / gist:32456eafe85f14c56af378d282b70b9a

Created October 3, 2018 11:16 — forked from slav123/gist:4274088

Extract Number From String MySQL

	select uExtractNumberFromString(mobile) from customer_masterCREATE FUNCTION `uExtractNumberFromString`(in_string varchar(50)) RETURNS INT
	NO SQL


	BEGIN


	DECLARE ctrNumber varchar(50);
	DECLARE finNumber varchar(50) default ' ';
	DECLARE sChar varchar(2);