update account set accouname=ltrim(accountname) where accountcode='000000001'
SUBSTRING(accountname, PATINDEX('%[A-Za-z0-9]%', accountname), 9999)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)