[SQL] UPDATE TABLE

SELECT *  FROM [Portal].[dbo].[ProviderUsers]
where Username like '%sptest5%'


Update [Portal].[dbo].[ProviderUsers]
SET AccessFailedCount =0,
    Lockout = 0
Where Username like '%sptest5%'


SELECT *  FROM [Portal].[dbo].[ProviderUsers]
where Username like '%sptest5%'