Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    2

    Unanswered: How to replace a character of data field

    Hi,
    How can I replace a charcter of "column/field" in the table.

    I have column in the table called "Ref". I need to relplace the character ":" with NULL or SPACE if the Ref column contain char ":".

    For example, if "Ref" column contain value of "abc:xyz", I need to replace ":" with NULL or SPACE. I need to do this from DBaccess or ISQL mode.

    I'm looking any funcitons like "REPLACE" which is available in SQL Server.

    Appreciate if you could provide any sample or source code to acheive this may be thru a Stored Procedure/routine etc..

    Regards,

  2. #2
    Join Date
    May 2004
    Location
    Barcelona, Spain
    Posts
    54
    Function REPLACE(string, replaced_substring, new_substring) exists in IDS too. You can include something like replace( string,':',' ') in your dbaccess statements or in spl.

    Iñaki

  3. #3
    Join Date
    May 2004
    Posts
    2
    hi thanks.. great help mate

Posting Permissions

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