>I have a table tasks: and the field name is Taskcode:
>
>In the taskcode: i can enter .01 or .01.102 or .01.102.103 like that
>
>So i have to find searching all rows in that table for that field(Taskcode) to see where maximum points are.
>each point represents one level:
>
>if it is .01 only it is 1 only one level
>
>if it is .01.12.14 then it is 3 has three levels, i see there are three points in it.
>
>ones i establish the maximum levels then i can do the other stuff.
>
>Can you please tell me, is it possible to get that info.
>
>Table name is Tasks and field name is Taskcode.
>
>Thank you very much for the information.
select top 1 occurs('.',TaskCode) as Level,* ;
from myTable ;
order by 1 descending
Cetin