How to count the no of commas in a field

[Rahel]

If I had a table for example called Authors

which has a field called Topics

<Art,Science,Astronomy,Geology>

How can I count all the commas and remember their positions?

I want to extract individual topics and then append them to another table.

I dont know how to look for commas in a string

Can anyone point me in the right direction



[sig][/sig]

 

[foxdev]

You'll probably need to use CharIndex(), and use the optional starting position parameter for the second and subsequent calls.
[sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]