Results 1 to 4 of 4

Thread: Need Help

  1. #1
    Join Date
    Jul 2011
    Posts
    13

    Unanswered: Need Help

    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...


    Please help me

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    please explain what it is that you're trying to trim off the name and why
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Jul 2011
    Posts
    13
    Thank you rt937 for your response...
    I got the solution....
    I modified the query it was typing mistake.....

  4. #4
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •