How Can I enter * into QBE???

[giga]

Hi,
Can you tell me, how can I enter '*' into QBE fields? There is problem because '*' is converted to '%'. For example:

in QBE field LM_CRCO = *

in generated SQL upper(LM_CRCO) like '%'

Flag Allow File Wildcards is off (False).

Thanx

 

[giga]

SORRY, this is not error. It is my bug :-( Deeply in my program is AllowFileWildcards set to True.
If AllowFileWildcards is False, then it is work fine.

Is there any way how can i enter * into QBE if AllowFileWildcards is True?

Thx

 

[Marco Kalter]

No, there is no escape character for this if AllowFileWildcards is True.