My Favorite MS-SQL Snippets
CachedSince:{ts '2024-11-02 22:22:56'}
SELECT REPLACE ([sz_Email], '#','@') AS sz_Email_Fixed
FROM [MyMy].[dbo].[Clients]
WHERE 1=1 AND [sz_Email] LIKE '%#%'
or
UPDATE MyTable
SET SZ_EMAIL = REPLACE ([SZ_EMAIL], '#','@')
WHERE 1=1
AND ID=39494
CachedSince:{ts '2024-11-02 22:22:56'}