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
11028 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

How many rows can sqlite handle?

1051

What packages(if any) has oracle provided for use by developers?

5719

Why do we use %rowtype & %type in plsql?

994

How does a self join work?

995

how to convert character strings to dates? : Sql dba

985

how mysql optimizes distinct? : Sql dba

1001

What is percent sign in sql?

1215

What is sql*loader and what is it used for? : aql loader

1097

how to include numeric values in sql statements? : Sql dba

1042

What is varchar sql?

1060

What is a sql profiler?

963

What is vector point function?

1005

what is auto increment? : Sql dba

966

What is cursor and its types?

996

how to get a list of columns in an existing table? : Sql dba

916