Link to home
Start Free TrialLog in
Avatar of DarrenJackson
DarrenJacksonFlag for United Kingdom of Great Britain and Northern Ireland

asked on

return specific values from a field in sql 2008

I have a column containing a string

"Field [Status] was changed from [Operational] to [Faulty] Field [Status] was changed from [Faulty] to [Decomissioned]"

What I am after is a t-sql script to show each of the values in a [Bracket] in separate columns

Any ideas

Regards
ASKER CERTIFIED SOLUTION
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of DarrenJackson

ASKER

excellent just the ticket

Cheers