Avatar of tanu80

asked on 

how to use substring function in sql server 2005

i have table named table tbl_Data.In it there is a column name servicename .This column has number of records like SCXE1023PLUS,SCSCXE10234PLUS,SSE1024,SSE10245.So i need a stored procedure that will first fetch the number of records like SCSCXEPLUS and  SSE. I need help on it.
Microsoft SQL Server 2005

Avatar of undefined
Last Comment

8/22/2022 - Mon