Member Avatar for newbie26
newbie26 0 Light Poster

hey.can someone help me..???
how can i filter records from the database depending on
the length of each record???

example..i only want to display records with the length
of the fieldname lastname <> 5.

what is the formula for this using crystal report??
im currently using this:

length({tablename.fieldname}) <> 5
but this doesn't work when i use it with not like syntax.

length({tablename.fieldname}) <> 5 and not({tablename.fieldname} like 'a*')

i badly need this..thanks in advance.
im using vb6, mysql and crystal report 8.

Edited by newbie26 because: n/a
  • 1 Contributor
  • 0 Replies
  • 52 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.