<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">
Either I'm blind or having a senior moment, but I can't seem to find the equivalent of CountFields in SQL. Does it exist? If yes, what is the name?<div><br></div><div>CountFields:</div><div><br></div><div><div>Returns the number of values (fields) in the string passed that are separated by the separator string passed. If the source string is binary data or you require case-sensitivity, use CountFieldsB instead.</div><div><br></div><div><div>The example below returns 5.</div> <div>Dim count as Integer</div> <div>Dim s as String</div> <div>s="Dan*Smith*11/22/69*5125554323*Male"</div> <div>count=CountFields(s, "*")</div></div><br><div> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Mit freundlichen Grüßen/Regards</font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px"><br></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Trixi Willius</font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px"><br></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica"><a href="http://www.mothsoftware.com">http://www.mothsoftware.com</a></font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Mail Archiver X: archive, clean and search email</font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica"><a href="http://www.beatrixwillius.de">http://www.beatrixwillius.de</a></font></p> <p style="margin: 0.0px 0.0px 0.0px 0.0px"><font face="Helvetica" size="3" style="font: 12.0px Helvetica">Fractals, 3d landscapes etc.</font></p> </div><br></div></body></html>