Len as a criteria in a query

[MikeKohler]

Is it possible to base a query on a record's length. In the build event why doesn't len(rencordname)=8, work. I don't get any errors but none of my records show up. An example of a value in my record is 40106.00 Wouldn't this have a length of 8?
Any help in this would be much appreciated, thanks
Mike Kohler
mkohler@telusplanet.net

 

[rac2]

Try a query that shows you the length of some of the values in your table. A lot depends on the datatype of the column.


SELECT rencordname, LEN(rencordname) FROM myTable;

 

[braindead2]

SELECT rencordname, LEN(cStr(rencordname)) as length FROM myTable where length = 8