I have one column in my SQL table where litres come in different style format. Column Name is litres.
UPDATE dbo.LostGear SET Litres = REPLACE(Litres, 'ltrs', 'L') WHERE Litres = 60ltrs
This is very time consuming as I have more than thousand records. Is there any SQL way in which 1000 entries can be formatted? I have mention all the different possibilities that exist in Litres column.
Desired Format: NumberL( e.g,20L,40L,...)