can anyone please help me to write a sql query. I just need the first number after the first backslash \ Please see the desire output. Thank you
| ColumnName | Desire Output |
|---|---|
| \2610 | 2610 |
| \2610\1178_2018 Bake Inn | 2610 |
| \2610\1178_2018 Change Outlook\2018-03-12 AOR & Page 33 DL | 2610 |
| \995645\1178_2018 Creek Choc | 995645 |
| \995645\1178_2018 Record Request\Club & Volume 12 | 995645 |
| \995645 | 995645 |
| \4323234\54724_2020 Add Image\2021-2019 Details Open\Checkbox-06- Value | 4323234 |
| \4323234 | 4323234 |
from Recent Questions - Stack Overflow https://ift.tt/3dh0oXn
https://ift.tt/eA8V8J
No comments:
Post a Comment