In the picture, you will see a table at the beginning that contains NULL in the Rounds column. After that, it shows 9th. How can I edit the data from 9th to NULL?
x
SELECT TOP (1000) [Rank]
,[Player]
,[Team]
,[Position]
,[Rounds]
FROM [Yahoo Fantansy Basketball 2020-2021].[Players].[Rank]
ORDER BY [Rank] ASC;
Advertisement
Answer
UPDATE Players.Rank SET Rounds = NULL WHERE Rounds = '9th'