Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Location
    Southern California
    Posts
    35

    Question Unanswered: Argument data type text is invalid for argument 1 of replace function

    I receive this error message when trying to update (remove comma's in the data):
    Server: Msg 8116, Level 16, State 1, Line 1
    Argument data type text is invalid for argument 1 of replace function.

    I noticed that the data type for this column is T_MEMO
    and I can't find anything regarding this data type.

    Here is my statement:
    UPDATE address
    SET address.street_address = (REPLACE(address.street_address,',',' '))

    Any thoughts/comments?

    Thanks,
    TechRick

  2. #2
    Join Date
    Dec 2002
    Location
    Czech Republic
    Posts
    249
    Not so simple
    See http://dbforums.com/showthread.php?threadid=625745

    You can use external program or XP to do it.

Posting Permissions

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