Results 1 to 4 of 4

Thread: sql statment

  1. #1
    Join Date
    Nov 2002
    Posts
    6

    Unanswered: sql statment

    I dont know if this is possible but......

    i have one text field wich has names, but in Portugal, names can have
    characters with accents like or .
    I want to change this characters. for example: change JOS SILVA
    TO JOSE SILVA.

    can you help me???

    thanks.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    update yourtable
    set textfield = replace(textfield,char(201),'E')

    repeat (or nest the replace functions) as necessary for other letters

    CHAR(integer) is a sql/server function, and 201 is

    rudy

  3. #3
    Join Date
    Nov 2002
    Posts
    6
    Thanks.

    Where can i find CHAR(integer) table to find another letters??

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002

Posting Permissions

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