How to Split Numbers in a string in SQL Server 2008

Question

am haveing a column as PoliceStationID in my table in that value is like KARGIL14268 i need to split the string and get the numbers onlyho to do this in sql server 2008 query

Andrea · Accepted Answer

Hi surendarPlease try the followingSplit a string and find the particlar part of string based on index using SubString in SQL ServerIt might help youCheers Andrea

How to Split Numbers in a string in SQL Server 2008

Company

Explore

Follow us

Contact Us