Recordset.filter 'NOT LIKE' (opposed)

[HWijngaarD]

Can anyone tell me how to get records with searching for a string which is not in the database?

In other words: the opposed of myrs.filter = "Number LIKE '102'"

sort of: "Number NOT LIKE '102'"

I would be grateful!

[mendhak]

Have you tried NOT Number LIKE ?

[mendhak]

This is vb.net or vb6?

[HWijngaarD]

I've tried that as well,
won't work!

I've tried myrs.filter = "NOT Number LIKE '102'"

and

I've tried myrs.filter = NOT "Number LIKE '102'"

(nice line anyway: To boldly go where robots have gone before)

[HWijngaarD]

It does work,
I have not looked hard enough and the solution is just to simple.

It's: mmm NOT LIKE mmm etc