Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ["165","184","192","209","242"]
- SELECT
- curso1,
- CASE WHEN COALESCE(curso1, '"')='"' THEN 0
- ELSE
- length(curso1)-length(replace(curso1, ',', ''))+
- (length(curso1)-length(replace(curso1, ' and ', ''))) DIV 5
- +1
- END
- FROM
- suaTabela
Add Comment
Please, Sign In to add comment