CountFields in SQL

[Thorsten Hohage]

Hi Beatrix,

On 2009-02-28, at 13:27, Beatrix Willius wrote:

> 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?

You'll find all the string functions here

	<http://valentina-db.com/dokuwiki/doku.php?id=valentina:vcomponents:vsql:reference:expr:functions:string 
 >


and I didn't find such a functions in there - so perhaps you should  
make a feature request.


A "ways to complicated" ;-) workaround is

	lenght(myString) - length(replace(myString, ',', '')) + 1



regards,

Thorsten Hohage
-- 

Valentina Technology Evangelist
generic objects  GmbH - Leiter Solution Center Nord