select below count (10) rows

Question

i have table like this .........

sno name idno
1 raju zts123456
2 praveen ap41234598765
3 kumar zts4567822

select only idno (10 below alphanumeric value row)

i wnt output like this.....

sno name idno
1 raju zts123456

venkata kumar · Answer

hi try select * from table where len(idno )

Jignesh Trivedi · Answer

hi have you resolve your problem?i cannot understand your quesition. what exact you looking? please provide more info.

Ravi Shekhar · Answer

try it select * from table where charindex('zts12'idno)>0 replace your value with zts12. You can give partial value or full value name.. It will return all rows according to your value.

Satyapriya Nayak · Answer

select * from table where idno like '% zts123456 %'