SQL statements sorted by a database

// Query records that end with a well
Select f_wellnumber, substring (f_wellnumber, 1, Len (f_wellnumber)-1)
As expr1
From cy_wellrecord
Where (f_wellnumber like '% Well ')

// Replace the word
Update cy_wellrecord
Set f_wellnumber = substring (f_wellnumber, 1, Len (f_wellnumber)-1)
Where (f_wellnumber like '% Well ')

// Query records with spaces in the middle
Select f_wellnumber, replace (f_wellnumber, '','') as expr1
From cy_wellrecord
Where (f_wellnumber like '% ')

// Replace spaces in the middle
Update cy_wellrecord
Set f_wellnumber = Replace (f_wellnumber ,'','')
From cy_wellrecord
Where (f_wellnumber like '% ')

// Update the ID
Update
Set a. f_wellid = B. f_id
From cy_wellrecord A, cy_well B
Where a. f_wellnumber = B. f_name