Count Characters

[#1]

I have a field that is numeric and I need to only select the ones that have 3 numeric characters.  How can I accomplish this?

What would the code be to flag the three digit elements?

If(Codes Character Count = 3, 'Three digit Flag', 'Other') AS [Digit Count],

Codes

02

03

04

111

222

333

Three digit Flag would return:

111

222

333

Other would return

02

03

04

Thanks in advance.

[swuehl · Accepted solution]

Try len(Codes) or len(trim(Codes)):

e.g. as list box field expression:

=if(len(Codes)=3,Codes)

Hope this helps,

Stefan

[#3]

Thanks swuehl, the Trim() solve my issue. 

[Johan_Kassing]

Thank you