How to split symbol data field on temp table to 5 columns?

[yosiasz]

Wasnt a similar question you posed already answered for you? Did you try that?

How to make User Defined Function split column to two columns text and numbers?

problem How to make UserDefinedFunction on sql server 2012 split column text to two columns . first column include text characters as unit measure only and second column include numbers only in case of integer or decimal etc..? create table #temp ( columnTextNumbers nvarchar(50) ) insert into #temp (columnTextNumbers) values ('3.5A'), ('5.50kg'), ('35.70kg'), ('9m') I need to make function split column name columnTextNumbers exist on temp table #temp to two columns first column is will …