want literal * in like EOQualifier problem

"Ty Shipman, CIO/CTO, Kagi" <[email protected]> Wed, 5 May 2004 17:02:26 -0700
Newsgroups gmane.comp.web.webobjects.devel,gmane.comp.web.webobjects.eof
Message-ID <p0610054fbcbf310bb24b@[157.22.137.101]>
Hello,

Thanks for any help that might be rendered here.

I am using 5.2.1, but this happens also in 4.5.1, not sure about 5.3.x

I want to product the following SQL code using an EOQualifier like statement
	select * from table where column like text*text2%

	When I pass the "text*text2%" to EOQualifier it comes out as:
		"...text%text2%"

I have tried various exscape sequences:
	text**text2%
	text\*text2%
	text%*text2%
	text[*]text2%

	But all end up with the replace of * with %

The docs do not tell me how to escape an * in the like qualifier to 
get it passed through as a literal, any more suggestions? Any tricks, 
any bugs #?

Thanks
ty
-- 
I am trying to become obsolete.   But I can not because I am autodidactic.

That is why I put lots of comments into the code, so I could forget.