SQL Query

[Former Member]

Hi,

I have following SQL_QUERY:

update table1 set STATUS = 4 where STATUS = 3

select * from VIEW where RATE_STATUS = 4

so now I like to change it like that:

select * from VIEW where RATE_STATUS = 4 and key = <value>

at the moment my query is in an constant. Could I concatenate my key-value inside of that?

THX Matt

[Former Member · Accepted solution]

hi,

hope this link will be useful

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

regards,

Sundararamaprasad