>the lenth of my filed(chr) is 11. some entry in this filed as =11 some are less than 11. now i want to selct records which is less than 11.
>
>in filed=345678901
>=12345678
>I want slect scond record
select * from myTable where LEN(myField) < 11
&& Not Rushmore optimizable
This is if myField is character. If it's numeric, you would need to use
LEN(transform(myField))<11
If it's not broken, fix it until it is.
My Blog