Counting characters entered in a field

[jpm2275]

Does anyone know how to figure out how many characters are in a field using a query? Ex: 345 would return 3, 34567 would return 5. I’m using the length expression, but it’s only returning the field length (which is preset). It’s not counting the characters.

Thanks

 

[PHV]

Perhaps Len(Trim([Field name] & ""))

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[pkailas]

you could try this. len(ltrim(rtrim(field)))

or if the Trim function is valid you could replace both the ltrim and rtrim with just Trim.

This will remove the padding and give you the lenght of characters.

 

[pkailas]

I suppose it would help to actually give you an example...

Select len(ltrim(trim(FIELD_NAME))) as Expr1 From TABLE