Calculate the number of rules in the field by comparing the length of the original string to it's length with all the dots removed, and adding one.
example ...
Code:Select length(rules)-length(replace(rules,'.'))+1 from whatever /
|
Results 1 to 5 of 5
Thread: SQL q !!Threaded View
|
Click Here to Expand Forum to Full Width |