Results 1 to 2 of 2

Thread: Update problem

  1. #1
    Join Date
    Jun 2007
    Posts
    197

    Smile Unanswered: Update problem

    Hi ,
    I want to update column such that

    If column consist

    JOBDESC=Resolve user queries post Go ?? Live

    I want to update only ?? to space

    A query such that where find ?? in that column replace with space?

  2. #2
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    Something like this might work :

    Code:
    update YourTable 
    set    YourColumn = REPLACE( YourColumn , '??' , ' ' )
    where  YourColumn like '%??%'
    Just not sure whether you can use the string just like that.

Posting Permissions

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