Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    5

    Unanswered: replace"***" in image path field.

    I am hoping someone will be able to help me with this.
    i have a table of accountholders with the following fields
    account_no
    account_name
    image_path
    the image_path field has a defaultvalue images/***.jpg
    I am looking for a query code to update the value in the image_path field by replacing the *** value with the value of the

    account_no field

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    update accountholders
    set image_path = replace(image_path, '***', account_no)

    EDIT: safer would be:

    update accountholders
    set image_path = replace(image_path, '***', account_no)
    where image_path='images/***.jpg'
    Last edited by jezemine; 11-22-06 at 00:06.

Posting Permissions

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