splitting data using sql

[Kunal P]

hi.. i needed help regarding an sql query.. i have an column.. containing alphanumeric values in this format.. no spaces.. 1213334Alsakasd12334 653453asdgsdgghj354 i want it to be split in to this type of a format as shown below colum1 column2 12312334 alksaksdf 6543534 wqeqweqe is this possible using sql in the first place.. if yes.. could anyone please help me out..

Kunal Piyush

[Marcus J Smith]

Is there any particular length? Try the site below to see if the substring option will work but that requires that you know how much of the string you need. SQL Substring Command[^]

SELECT SUBSTRING(ColA, 10) AS ColumnA, SUBSTRING(ColB, 10) AS ColumnB FROM TABLE

---

CleaKO

"I think you'll be okay here, they have a thin candy shell. 'Surprised you didn't know that." - Tommy Boy
"Fill it up again! Fill it up again! Once it hits your lips, it's so good!" - Frank the Tank (Old School)

[Kunal P]

the numeric length is variable.. i tried this Select left('123Delhi',Patindex('%[A-Z]%','123Delhi')-1 )Add1 , substring('123Delhi',Patindex('%[A-Z]%','123Delhi'),Len('123Delhi')) Add2 from address but i want that the pattern applies to all the columns.. also..... the result appears 4 times...mean 4 rows.

Kunal Piyush