Seperate the number part from the alphabeths in a string 1

[infinitizon]

Hi all,
I want to be able to seperate the numbers from the alphabeths in a string.
E.g
30d should be seperated as 30 and d
120yyy should be seperated as 120 and yyy

Does anyone have ideas

____________________
Men put up a strong face just to cover their weaknesses...good!
But a smile makes them live longer....
Which would you choose?

Think about it.

 

[gmmastros]

I blogged about this a while ago.

http://blogs.lessthandot.com/index.php/DataMgmt/DataDesign/extracting-numbers-with-sql-server

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[infinitizon]

@gmmastros: Thanks 4 d post, its great

____________________
Men put up a strong face just to cover their weaknesses...good!
But a smile makes them live longer....
Which would you choose?

Think about it.