How to read the character ] from a query 1

[Bresart]

Hi, for many records i have a field in a table with the text [...]. I want to obtain in a query only the records that have this text, so in the design view of the query, in the field desired i include as criteria:

Like '*' & '[' & '*'

But the query returns no records, the character [ is not read correctly.

Is there any other way of including this character on the criteria condition?

Thanks in advance.

 

[lespaul]

why not just:

LIKE "*[*"

is this in a query or VBA?

Leslie

Have you met Hardy Heron?

 

[Bresart]

Thanks lespaul. That text gives the same result.

It's a query.

 

[lespaul]

what kind of field is it?

Leslie

Have you met Hardy Heron?

 

[Bresart]

lespaul, the field type is memo.

 

[PWise]

try

WHERE InStr([Fieldname],"[")>0

 

[Remou]

Oddly enough, it is:

Like '*[[]*'

You need to bracket special characters.

 

[lespaul]

thanks remou, have a star; still learn something new everyday!

les

 

[Bresart]

Thanks pwise Remou.

pwise, it works correctly.

Remou, with the condition

Like '*[[]*'

the query gives the matching records, but with the condition

Like '*[]]*'

the query gives no record.

 

[Remou]

There is a little oddity, I'm afraid:

Like '*]*'

 

[Bresart]

Thanks Remou.