SQL Server Parse Key Value from text

Question

i am a novice programmer in sql.

I want to grab some key value pairs from the text in sql column

e.g.

some text[Key1=Val1]some text[Key2=Val2][Key3=Val3]some text

i want a function which takes Keyname as input & returns the value related with it if found.

GetValueFmKey('Key1')

should return Val1 and like on.

Note: the specified values are in text it may have pre or post text exists.

Sumit Jolly · Answer

It looks like KeyValue Pair problem eg.. variable Dictionary has two records A -> Sumit B -> Ashutosh Dictionary(A) should give Sumit and so on... You can implement it on sql OR .Net OR JavaScript Earlier I used to do this at Sql level but now I prefer doing some stuff at client side following principle of FAT client and thin SERVER. Does it make sense? Let me know if you still want to do in SQL and paste some code view sql if you already have written twitter @sumitjolly