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 texti 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.
Guest UserPosted Jul 21, 2014, 3:53 AM
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