Re: ALLTRIM( ) in SQL statement

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Man-wai Chang <toylet.toylet@xxxxxxxxx>
Date: Mon, 12 Mar 2007 19:33:56 +0800

Question: Why does the same SQL statement with an added ALLTRIM in
the WHERE clause result in a response consisting of 3 rows?

Partial match, which is the default of SQL processing in V.Foxpro.

"1"="0"="10"=""

--
.~. Might, Courage, Vision, SINCERITY. http://www.linux-sxs.org
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Ubuntu 6.10) Linux 2.6.20.2
^ ^ 19:32:01 up 2 days 4:04 1 user load average: 1.00 1.00 1.00
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk
.

Follow-Ups:
- Re: ALLTRIM( ) in SQL statement
  - From: Man-wai Chang

References:
- ALLTRIM( ) in SQL statement
  - From: David

Prev by Date: Re: How to execute remote program?
Next by Date: Re: ALLTRIM( ) in SQL statement
Previous by thread: Re: ALLTRIM( ) in SQL statement
Next by thread: Re: ALLTRIM( ) in SQL statement
Index(es):
- Date
- Thread

Relevant Pages

Re: Simply Amazing - Amazingly Simple! S33P
... Mozilla Thunderbird users don't need tinyurl... ... Might, Courage, Vision, SINCERITY. ...
(alt.games.mame)
Re: [OT] testing
... COPY, RED LEADER. ... Might, Courage, Vision. ... SINCERITY. ...
(microsoft.public.fox.programmer.exchange)
Re: [OT] testing
... GOLD LEADER, where are ya? ... Might, Courage, Vision. ... SINCERITY. ...
(microsoft.public.fox.programmer.exchange)
Re: Select alltrim(str(numeric)) works, but why?
... And ltrim(), rtrimand trim ... Might, Courage, Vision, SINCERITY. ...
(microsoft.public.fox.programmer.exchange)
Re: [OT] Clipper vs Foxpro programmers
... Not to mention the precursor to ODBC -- RDD, short for Replaceable Database Driver. ... Might, Courage, Vision. ... SINCERITY. ...
(microsoft.public.fox.programmer.exchange)