Skip to navigation
Tsql remove none ASCII character from the left
10.02.21
--SELECT --RIGHT([av19_supplier], NULLIF(LEN([av19_supplier])-1,-1)) -- ,ASCII(LEFT([av19_supplier], 1)) from UPDATE SL.dbo.av19_supplier_style_details --as l SET [av19_supplier] = RIGHT([av19_supplier], NULLIF(LEN([av19_supplier])-1,-1)) WHERE ASCII(LEFT([av19_supplier], 1)) > 126 OR ASCII(LEFT([av19_supplier], 1)) < 48 OR ASCII(LEFT([av19_supplier], 1)) IN (32,58,59,60,61,62,63,64,91,92,93,94,95,96)
https://www.w3schools.com/SQL/func_sqlserver_right.asp
Reply
Anonymous
Information Epoch 1711693194
Clarity is better than cleverness.
Home
Notebook
Contact us