SQL query equivalent to ListLen()
Posted on 2006-07-20
I need this quickly. Find total list of words in the table row, "KEYWORDS". It's a comma delimited list.
<cfquery name="Query" datasource="Words">
select area_id, title, keywords
where (len(keywords) < 80)
That gives total length of combined elements in the list. I need the total number of elements, that is, the total words in the list "KEYWORDS". With Coldfusion I can use ListLen(). How should I edit the query above for an equivalent way to do this in SQL2000?