troubleshooting Question

SQL View Syntax

Avatar of HKFuey
HKFueyFlag for United Kingdom of Great Britain and Northern Ireland asked on
SQL* Views
6 Comments1 Solution25 ViewsLast Modified:
I have a view (Not created by me) :-
SELECT        UPPER(SUBSTRING([Stock Code], PATINDEX('%[^0]%', [Stock Code]), LEN([Stock Code]))) AS StockCode, [Stock Code] AS StockCode2
FROM            dbo.[tbl_My_Table]
WHERE        ([Stock Code] = '02-1600HF')

It returns:
StockCode     StockCode2 (I added this column)
2-1600HF      02-1600HF      

This view feeds into a BI system and I don't want to break it, does anyone know what "PATINDEX('%[^0]%'" does and why it would be used?

I need to keep the leading Zeros 'StockCode' does not have them.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros