SELECT * FROM MyTable WHERELEN (ALLTRIM (Filed)) < 11
>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