I have certain values such as 'Test123' , 'a3456' , 'cgf999' Which i need to split into string and numerics in sql server 2012.
'Test123' -> var1 = Test , var2 = 123
'a3456' -> var1 = a, var2 = 3456
'cgf999' -> var1 = cgf, var2= 999
asked Jun 28, 2016 at 07:45 PM in Default