SQL7 Full-text search handles this automagically.
That is, searches for O'Neill without any massaging
of O'Neill to O''Neill, and so forth.
Perhaps Verity does, too. But Verity doesn't
allow standard SQL in the same breath as SQL7
full-text search does. Perhaps the new Verity
K2 will add amazing new functionality.
best, paul
At 11:48 AM 12/22/00 -0500, you wrote:
>I am not sure why someone would want an apostrophe in their last name, :)
>but I need to know how to get around that when writing SQL queries
>that search records for last names contain apostrophes.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
