string query = "update usage SET Name = TRIM(Both '"' from Name) where duration >0";
when i am trying to write this query in my code....After the Both i have one '' (double quotations). system is considering
as one string "update usage SET Name = TRIM(Both '"
and this one as second string....
' from Name) where duration >0";
I'm getting error saying ;--missing...
Perhaps you should do a little work yourself before posting to us then.
It might also be worth putting in a proper title to your post as everyone who posts here needs help (in one way or another).
Not only does this ensure you get a better response it also doesn't waste people's time.