Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2012
    Posts
    4

    Question Unanswered: REPLACE Function

    Hi folks,

    Can you please guide me to ways of using REPLACE function, and the important question is REPLACE replace/effect/change the original data that stored in the data base or just replace the output results in the query?

    Thanks guys in Advance...

    Cheers

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    Check here

    IBM Informix Dynamic Server v10 Information Center

    The syntax is not version dependant ( ie it must must >= 10 )

    All these functions will only display the SELECTED data in a different way, they will never modify the data in the db tables!

    You need to use the UPDATE sql statement to modify the data in the db tables

    Maybe a bit of reading the Guide to SQLyntax manual would help :-)

  3. #3
    Join Date
    Jun 2012
    Posts
    4
    Quote Originally Posted by begooden-it View Post
    Check here

    IBM Informix Dynamic Server v10 Information Center

    The syntax is not version dependant ( ie it must must >= 10 )

    All these functions will only display the SELECTED data in a different way, they will never modify the data in the db tables!

    You need to use the UPDATE sql statement to modify the data in the db tables

    Maybe a bit of reading the Guide to SQLyntax manual would help :-)
    Thank dear for your valued feedback, appreciated!!

  4. #4
    Join Date
    Jun 2012
    Posts
    4
    Quote Originally Posted by leo_ultra_leo View Post
    Hi folks,

    Can you please guide me to ways of using REPLACE function, and the important question is REPLACE replace/effect/change the original data that stored in the data base or just replace the output results in the query?

    Thanks guys in Advance...

    Cheers
    Thanks again, but I'll be grateful if you help me in this..

    Assume that I have one table named Table1, and contains these values, as the following:

    Table1
    -------
    1
    2
    3
    4
    5

    I want select from this tables as the output should replace the numbers with number names, in other word, the out out should be as this:

    one
    two
    three
    four
    five

    In other word, I want to know what is the right syntax for dealing with REPLACE function. Looking forward for your help in this.

Posting Permissions

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