"Mike G." <[EMAIL PROTECTED]> writes:
> create a table with a data type of varchar (50) and name it email
> insert into this table the following values:
> [EMAIL PROTECTED]
> Execute the following statement:
> SELECT CASE WHEN count(substring(email FROM '@.')) > 0 THEN count(substring(email
> F
To reproduce:
create a table with a data type of varchar (50) and name it email
insert into this table the following values:
[EMAIL PROTECTED]
Execute the following statement:
SELECT CASE WHEN count(substring(email FROM '@.')) > 0 THEN count(substring(email FROM
'@.')) ELSE 0 END, email FROM y
