That's what the contain operator is for ;-) Also Witango adjusts the operators to pick from based on the datatype of the column. You can't contains or like on an integer
Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm -----Original Message----- From: Harpreet Matharu [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 1:04 PM To: [EMAIL PROTECTED] Subject: RE: Witango-Talk: Bug in Search Action? try the 'LIKE' syntax LIKE '%%' '%test%' - contains test 'test%' - begins with test '%test' - ends with test cheers... -----Original Message----- From: Dan Stein [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 1:59 PM To: [EMAIL PROTECTED] Subject: Witango-Talk: Bug in Search Action? Anyone else found this or is it just me. In criteria I am looking for contains ( I've tried @, a, .) and they all fail because in the debug I can see it is doing @%% Or A%% Or .%% When it should do %a% Or [EMAIL PROTECTED] Or %.% If someone else can confirm I'll report it. Seems pretty serious to me. -- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
