CountFields in SQL

[Beatrix Willius]

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?

CountFields:

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.

The example below returns 5.
Dim count as Integer
Dim s as String
s="Dan*Smith*11/22/69*5125554323*Male"
count=CountFields(s, "*")

Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: archive, clean and search email
http://www.beatrixwillius.de
Fractals, 3d landscapes etc.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.macserve.net/pipermail/valentina/attachments/20090228/75f92a1a/attachment.html