find all records that have text field with 255 characters

[NotSoSmartUser]

Hi there,
I have a database with cut off data (error when import from different source) and assumed by using LEN query it will return any records which has 255 characters from the ProductDescription field...

I saw one suggestion by using LEN([fieldname]) however not sure how to apply this the select query under design view, can anyone please assist ?

many thanks

 

[rjoubert]

SELECT * FROM TableName WHERE Len([fieldname]) = 255

 

[NotSoSmartUser]

Hi Rjoubert,
it works -
thanks and much appriciated
cheers,