I have a field with something like `okbogkbogkbokgbokgobkgobkofkgbokfgbo&name=fokdofkd&okfaos`

I'd like to extract the `name = value` from the data.

How can I do that using SQL Server 2008 in efficient way?
thank you