select below count (10) rows

Accepted answer

hi try
select * from table where len(idno)<10

hi,

have you resolve your problem?i cannot understand your quesition.
what exact you looking?

please provide more info.

Ravi Shekhar12y ago

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 Nayak12y ago

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