Simple I'm sure

[adam7]

Hi ther,e been using crystal for years so why don't I know this!!!! Anyway, using crystal 8.5, and in a formula I want to say NOT LIKE, so for instance

{field.bob1} NOT LIKE "Customer*"

So it picks out everything other than the records starting with Customers.

Using SQL 2000

I'm sure it's easy, but would really appriciate some help.

Cheers

 

[IanWaterman]

not({field.bob1} LIKE "Customer*")

 

[adam7]

Knew it was simple!!! Thanks a lot for that.