Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT ship,
- STUFF
- (
- ship,
- CHARINDEX(' ', ship) + 1,
- CHARINDEX(' ', ship, CHARINDEX(' ', ship) + 1) - CHARINDEX(' ', ship) - 1,
- REPLICATE
- (
- '*',
- CHARINDEX(' ', ship, CHARINDEX(' ', ship) + 1) - CHARINDEX(' ', ship) - 1
- )
- )
- FROM Outcomes
- WHERE ship LIKE '% % %'
- --проблема в том, что если пробелов больше чем 2 то сосем бибу
- --рекурсия?
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement