DarrenJackson
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
"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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Cheers