> For the complete documentation index, see [llms.txt](https://kythuat.dtechvn.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://kythuat.dtechvn.com/sql-server/ham-tach-so-va-chu-kh-i-chuoi.md).

# HÀM TÁCH SỐ VÀ CHỮ KHỎI CHUỖI

```sql
-- HÀM TÁCH SỐ RA KHỎI CHUỖI
Create function UDF_ExtractNumbers
(  
  @input varchar(255)  
)  
Returns varchar(255)  
As  
Begin  
  Declare @alphabetIndex int = Patindex('%[^0-9]%', @input)  
  Begin  
    While @alphabetIndex > 0  
    Begin  
      Set @input = Stuff(@input, @alphabetIndex, 1, '' )  
      Set @alphabetIndex = Patindex('%[^0-9]%', @input )  
    End  
  End  
  Return @input
End
```

```sql
---- HÀM TÁCH CHỮ RA KHỎI CHUỖI
Create function UDF_ExtractAlphabets
(  
  @input varchar(255)  
)  
Returns varchar(255)  
As  
Begin  
  Declare @alphabetIndex int = Patindex('%[^a-zA-Z]%', @input)  
  Begin  
    While @alphabetIndex > 0  
    Begin  
      Set @input = Stuff(@input, @alphabetIndex, 1, '' )  
      Set @alphabetIndex = Patindex('%[^a-zA-Z]%', @input )  
    End  
  End  
  Return @input
End
```

```sql
// CỘT IDNAME CHỨA CHUỖI KÝ TỰ DẠNG: HH0001 => 0001 | HH 
Select dbo.UDF_ExtractNumbers(IDName) as ID, 
dbo.UDF_ExtractAlphabets(IDName) as Name 
from TestTable

```