gdmprog1

You don't explain enough about what the data looks like and the result you are trying to get. But couldn't you break the url.name into pieces based on spaces and then select LIKE for each piece?

You have <cfoutput>#SQL#</cfoutput> but in the cfquery you only have SQL, try enclosing the #SQL#

I have data for a drop down box that is up to 250 digits. This places the drop down box outside the range of the screen. I need to limit the drop down box to 150 digits on the screen but also need to display the extra 100 digits somehow. …