select enam ,eempno , (len(phoneno) - len(replace (phoneno,',',

i want count no of values in a column i.e
enam eempno phoneno
x 1 (98765,09887,096561,87964579,156678,678900876)
that means if i select phone no from table i want to get
total count of phone numbers i.e 6

Question Posted / nitin vartak

8 Answers
11234 Views
Satyam, I also Faced
E-Mail Answers

Answer Posted / nitin vartak

select enam ,eempno , (len(phoneno) - len(replace
(phoneno,',',''))) + 1 from TableName

Is This Answer Correct ?

5 Yes

3 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

what is the difference between myisam static and myisam dynamic? : Sql dba

1050

How do sql databases work?

980

How do I find duplicates in two columns?

1128

When are we going to use truncate and delete?

964

what is a database transaction? : Sql dba

1152

Is grant a ddl statement?

886

Mention what are the benefits of pl/sql packages?

1058

What is meant by temporal data?

939

Can triggers stop a dml statement from executing on a table?

1066

Can we group by two columns in sql?

967

Why do we use sql constraints?

1153

what is sub-query? : Transact sql

1081

Is stored procedure faster than query?

949

Define tables and fields in a database

1111

What is sql character function?

1051