Tags for char_length
summing serial numbers in a single column with out using an external function.
I have an audit table that I am creating a view for so I can create some reporting for. In the original table, ther serials are separated by a comma and are all in one comlumn. Here is an example:   serial_number                                                          
sum sql char_length
Creating a Total
I have a column that counts the amounts of serial numbers in a column. This column can have multiple serials separated by a comma. Here is the SQL to create this column: (char_length(serial_number) - char_length(apputil_user.oreplace(serial_number, ','))) + 1 as num_serials  
sql sum char_length