SQL question

Admiral Huddy · 8 Apr 2021 at 11:29

I'm trying to query a Sybase database, which has an email column. The column may have multiple email addresses separated with a comma. I'd like to count the total amount of emails specified in the column.

So for example, the email column could look like this:

'sid@ email. co.uk'
'harry@fakeemail. co.uk, marry@ anothermail. com'
'julie@ juliemail.co.uk, john@ anothermail.com,[email protected]'

so the count is 6

Thanks

Admiral Huddy · 8 Apr 2021 at 17:18

I'll give that a try touch.

I tried string_split before realising it wasn't supported.. I'll give sa_split_list a try too.

Cheers

Admiral Huddy · 8 Apr 2021 at 17:30

That worked.. for some reason, my editor didn't like the LENGTH so I changed this for LEN