WHERE
companyName LIKE '#form.companyName#%'
the LIKE is similar to 'contains'. the % is a wildcard character, so
putting it at the end of the string means any string that starts with
#form.companyName#.
On 2/19/06, Rick Faircloth <[EMAIL PROTECTED]> wrote:
> What I'm after would be a list
> of the company names that
> match the letters in the form field
> that start with the first letter of
> the company name...not with the
> form field letters just anywhere in the
> name...
>
> E.g....
>
> Search for the letter "A" would bring up
>
> Allstate
> AIM
>
> Not:
>
> Hartford
> Allstate
> AIM
>
> or
>
> if the search was for "All"...
>
> Allstate
>
> would match...
>
> ???
>
> Rick
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232883
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
