length function

[#1]

Hi,

Does anyone know how to use a length function i.e. only bring back data from a certain field if the characters for example are greater than 5?

Any help will be welcomed?

Thanks Naz

[tresesco]

where len(field)>5 ;

[anbu1984]

Where Len(Trim(YourField)) > 5

[maxgro]

exclude row --> tresesco

change field value (or set null) --> below

load

     ....

     if(len(field)>5, field) as field,           

     if(len(field)>5, field, '>5') as field1,     

     ....

from

     ...;