>I have a table with a field that contains one or more strings separtated by commas. I need a SPT that can count the number of strings. The table is a db2 file.
The following expression will return the number of items in the comma separated list (# of commas + 1) in MS SQL Server. I dunno if DB2 has compatible string functions
LEN(myfield) - LEN(REPLACE(myfield, ',', '')) + 1
--sb--