What would the best way to approach the following: I have a form field called "keywords" and would like to search for records from the SQL 2K database from two columns EventTitle and EventDescription. However, I need this to be case insensitive.. so that i I type mike or Mike I will get the record if either mike or Mike is in either of the two columns in the DB? Right now I am trying to use
form.keywords LIKE %EventTitle% and was thinking UCASE around the operands would work. Thansk for any input. Mike ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
