Results 1 to 2 of 2

Thread: prob in query

  1. #1
    Join Date
    Apr 2006
    Posts
    6

    Red face Unanswered: prob in query

    hi......
    i have one table in which 1 column is varchar & contains values like
    "abchi1'kl'www"
    "kkk3445'kk'hhd"

    now i want to write query to remove single qoutes from tht columns
    can u plz tell me it's urgent

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    If you have ASE 12.5.2 or later:

    Code:
    update table set colname=str_replace(colname, "'", null)
    Michael

Posting Permissions

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