Getting only Numeric Value

Question

Dear Frnds I am having a field which contains string(characters) and numeric value example:-aamir12000. i just want to get the number not any text from it without using Substring(). please help in my query. Thanks & Regards Aamir

Satyapriya Nayak · Answer

Hi Aamir Try this... ALTER FUNCTION dbo.udf_GetNumeric (@strAlphaNumeric VARCHAR(256)) RETURNS VARCHAR(256) AS BEGIN DECLARE @intAlpha INT SET @intAlpha = PATINDEX('%[^0-9]%' @strAlphaNumeric) BEGIN WHILE @intAlpha > 0 BEGIN SET @strAlphaNumeric = STUFF(@strAlphaNumeric @intAlpha 1 '' ) SET @intAlpha = PATINDEX('%[^0-9]%' @strAlphaNumeric ) END END RETURN ISNULL(@strAlphaNumeric0) END SELECT dbo.udf_GetNumeric('aamir12000') AS Expr1 thanks

Satyapriya Nayak · Answer

Hi Aamir Try this... using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Text.RegularExpressions; namespace WindowsFormsApplication6 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void button1_Click(object sender EventArgs e) { string s1 = aamir12000; string value = Regex.Replace(s1 @[\D] ); MessageBox.Show(value); } } } Thanks If this post helps you mark it as answer