Replacing values in SQL Query

[adamishak12]

All, 

This is my current query in SAP 

SELECT "Project","Project Name","Labor Budget","Labor Billed","Address1","period","year","month","EnergyType" From REA

I want to replace certain values inside the Energy Type column. For example I have rows like this 

Project	Project Name	Labor Billed	Labor Budget	Address1	Period	Year	Month	EnergyType
1	Elmers Ave	171100	2550	460 Madison Ave	201501	2015	1	solar
1	Elmers Ave	171100	3000	460 Madison Ave	201601	2016	1	Solar
1	Elmers Ave	171100	3750	460 Madison Ave	201507	2015	7	solar

Project	Project Name	Labor Billed	Labor Budget	Address1	Period	Year	Month	EnergyType
2	Avenue St	231100	2550	11 lee ave	201501	2015	1	Wind
2	Avenue St	231100	3000	12 lee ave	201601	2016	1	Wind (L)
2	Avenue St	231100	3750	13 lee ave	201507	2015	7	Wind (L)

I would like to replace underscore "solar" with capital "Solar" & replace "Wind (L)" with "Wind" Is this possible?

[Edrilan_Berisha · Accepted solution]

Hi,

what are you talking about? What is meant with "this is my query in SAP"? What are you using here? SAP offers a wide range of different products. Are you developing in ABAP? Are you using SAP SAC?

Here you see how you can update (this means changing certain rows in a data base table) in ABAP:

https://help.sap.com/doc/abapdocu_750_index_htm/7.50/en-US/abapupdate_source.htm

Best,

Edrilan Berisha