Post reply

Add a string to every result of the view

  • June 18, 2014 at 8:25 am

    #290193

    Hi

    I have a view:

    SELECT * FROM VW_DEVOLVESELECCAO

    I want to add another record to the view but I cannot open the view and change the code.

    Suppose the result set of the view is:

    1,1,1

    1,2,1

    ......

    1,3,4

    I want to add the value pedro

    like

    1,1,1,pedro

    1,2,1,pedro

    ...............

    1,3,4,pedro

    How can I change the sellect to join the resukt of the view with the string that I want to send?

    Thanks

  • June 18, 2014 at 9:37 am

    #1722852

    SELECT *,'pedro' FROM VW_DEVOLVESELECCAO

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply