This is my Technical area of troubleshooting and learning new Programming skills and many more. Here you will find answers for many new technologies like asp.net 2.0/3.5,4.0 C# access, mysql, Amazon Webservice ,Sql-server, JD Edwards, SAS, Salesforce, APIs, MVC and many more. please visit & discuss.
Wednesday, August 23, 2017
remove leading zeros SQL Server
PATINDEX('%[^0]%', glcknu+'.'), LEN(glcknu)) = '' THEN '0' ELSE SUBSTRING(glcknu, PATINDEX('%[^0]%', glcknu+'.'), LEN(glcknu)) END
No comments:
Post a Comment