I have a table with 2 fields
JOBID PARAMS
FFR054 Test1=1;Test2=2
FFR054 Test1=5;Test2=6
FFR054 Test1=2;Test2=7
Now when i run an update query. I want to remove all the Test1 entries from PARAMS field. The new table structure should be like
JOBID PARAMS
FFR054 Test2=2
FFR054 Test2=6
FFR054 Test2=7
Thanks for any help