Asterix character in string

[Graham Ramsay]

How can I return only those records that do not have an asterix in a text field.

If records are:

01 Apples 1 *
02 Apples 2
03 Oranges 12
04 Oranges 23 *
05 Apples 3
06 Apples 4 *

I need to get:

02 Apples 2
03 Oranges 12
05 Apples 3

Obviously, because somebody many moons ago chose the
asterix as a marker we're stuck with it.

Thanks.

 

[Graham Ramsay]

Sould be asterisk of course.

 

[ExcellentGent]

Use an SQL WHERE clause:

WHERE InStr([fieldname], "*") = 0

 

[John Spencer (MVP)]

Perhaps the following

Not Like "*[*]*"

 

[Graham Ramsay]

"ExcellentGent" wrote

Use an SQL WHERE clause:

WHERE InStr([fieldname], "*") = 0

Thank you. You are indeed a most excellent Gent.