Re: SQL query problem with character comparison.

Select * from Account, Bank where alltrim(account.bank_id) =
alltrim(bank_bank_id) and alltrim(account.Bac) = alltrim(Bank.Bac) and
alltrim(Bank.Bac) = '0000991' and not Deleted()

1. DO NOT use alltrim()! If you want partial match, use "$".


--
.~. 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.3
^ ^ 20:27:01 up 2 days 6:45 0 users load average: 1.01 1.04 1.00
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk
.

Loading