Select Using field data length

[imtmub]

Hi All,
How to select the records in table1, field1. Bcz in field1 some data is more then 100(Field Length) and some are less than 100. so i want to filter the records the data length is more than 100.

[srinit]

Hi All,
How to select the records in table1, field1. Bcz in field1 some data is more then 100(Field Length) and some are less than 100. so i want to filter the records the data length is more than 100.

hi....try like below
[CODE]
select * from table1 where len(field1)<100

[debasisdas]

I don't understand why you are posting such questions here.

[imtmub]

Hi Srinit, Thanks for the code. Now i can filter the records using length. Because those records are causing error. Anyhave thanks for ur efferts.
Sorry Mr.Debasisdas bcz i don;t know command for filtering records using length. If anyone know where i can find all the commands of sql let me know website name.

Thanks

[debasisdas]

There are hunderd of sites /web pages for the purpose , u can find all that by little googling. Thats very simple.