How to convert this sql into my script ?

[bhaveshp90]

Hello,

I have my SQL query as shown below,

CASE

WHEN [Probable_Position_wo_LDs] NOT LIKE '%#%'

  THEN CAST(REPLACE(SUBSTRING([Probable_Position_wo_LDs],4,10),',','') AS FLOAT)

END AS [Probable Risk Position w/o Damages (R-C-Cont)],

How can I convert this into my script and load? Any help is greatly appreciated.

Dummy Data:

Project_Number	Risk_Contingency_WBS	Probable_Position	Region	Snapshot_Date	Probable_Position_wo_LDs	Probable_Contractual_Penalties	Full_impact_Contractual_Risks	Net_Full_Impact	Probable_Managed_Impact
P04950	168192.74	(C) -1942.73999999999	ANZ-ASEAN	11/30/2017	(C) -1942.73999999999	(R) 0	(R) 0	(R) 2900000	(R) 113250
P06012	5395.92	(R) 181904.08	ANZ-ASEAN	11/30/2017	(R) 70604.08	(R) 111300	(R) 445200	(R) 591000	(R) 176170
P06233	10000	(C) -36000	ANZ-ASEAN	11/30/2017	(C) -36000	(R) 0	(R) 0	(R) 155000	(C) -28600
P06271	63815	(C) -63815	ANZ-ASEAN	11/30/2017	(C) -63815	(R) 0	(R) 0	(R) 20000	(R) 9000

thanks

Bhavesh

[bhaveshp90]

The script loaded correctly when I removed the end statement

[bhaveshp90]

That was very helpful, thank you