Help: Len function confusing me.

See more:

SQL

VBA

I am writing a query in VBA and i am having issues with the Len function:
Code:

sql = "Select [" + fld.name + "] "
                    sql = sql + "from [" + tbl.name + "] "
                    sql = sql + "Where len([" + fld.name + "]) <= '10'"

If I filter for a length less than 10 the process works and the query outputs all records whose length is less than 10. However if I use '10' or greater it gives me zero records? I tried using MS Access and it repeated the problem.

Seriously confused...