Building Sql query string processing

Question

I need help in building up one SQL query

My requirement is to get folders present in the path passed (Excluding subfolders)

When I pass the parameter like input : D245E7DA\Entertainment\

expected output:

D245E7DA\Entertainment\Movies\
D245E7DA\Entertainment\Series\

not expected this output:

D245E7DA\Entertainment\Movies\
D245E7DA\Entertainment\Series\
D245E7DA\Entertainment\Series\Ramayan
D245E7DA\Entertainment\Series\Geetha

You can also use stripping functions. Just remove all data after second "\" That should work. — rohitcoder
– rohitcoder, Commented Mar 26, 2020 at 8:15

Gordon Linoff · Accepted Answer · 2020-03-26 11:53:47Z

1

You can use like:

where folder like concat(<input>, '/%') and
      folder not like concat(<input>, '/%/%')

answered Mar 26, 2020 at 11:53

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1