|
To catch both upper and lower you may want to try Delete from tablex where UPPER(FLDA) like '%GOLD%' John Neat Bumper Stickers - Get yours today. http://www.gwbush.com/store/ ---------------------------------------------------------------- "If" I understand your question, would a where portion look similar to the follow: where idesc like '%GOLD%' In an interactive sql to select items that contain gold in the item description - that works. HTH Mark
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.