Loading

what condition case when related to portion key mean ?

ahmed elbarbary

5y584

I work on sql server 2012 I don't understand condition below do
this condition as below
case WHEN Po.PortionKey LIKE '%[_]%' THEN SUBSTRING(Po.PortionKey, LEN(LTRIM(RTRIM(Po.PortionKey)))+1,LEN(LTRIM(RTRIM(Po.PortionKey)))) end as modifiedportionkey
what condition above mean
can please give me sample

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Rajanikant Hawaldar5y ago
if the PortionKey contains an underscore, return the empty string, else NULL. Although, this is somewhat simplified. If PortionKey would have some leading spaces, you could actually get back some non-blank characters.