What are you comparing it to? You can use the LIKE statement in SQL to
search large records...
SELECT x FROM t
WHERE Field LIKE '%SEARCH_STRING%'
The %'s are wild cards they will match zero or more characters.
I wrote a tutorial on using LIKE in SQL at http://www.secretagents.com check
it out.
Pete Freitag ([EMAIL PROTECTED])
CFDEV.COM
ColdFusion Developers Resources
http://www.cfdev.com/
-----Original Message-----
From: Michael S. Kimmett [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 30, 2001 12:22 PM
To: CF-Talk
Subject: Easy way to Compare large text
Howdy,
Ok, I need some suggestions on an easy way to compare large text fields from
a DB table. I was thinking about using the CF function Evaluate and sending
the user a message saying that yes these strings are similar or no they are
not. Well, that is the simple way to do things. Does anyone have an idea
about other CF functions that might give me better results?
Thanks in advance.
Michael
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
