CF newbie: Search Non Case Sensitive Results

[Mark Armstrong]

Its seems by default searching records is case sensitive, how do I tell 
the search to ignore case?

my search code:
<cfquery datasource="datasource" name="getMembers">
        SELECT *
        FROM members
        <cfif isDefined("search")>
        Where Lastname like '%#search#%'
                or firstname like '%#search#%'
                or homeAddress like '%#search#%'
                or workAddress like '%#search#%'
                or homeCity like '%#search#%'
                or workCity like '%#search#%'
                or homeState like '%#search#%'
                or workState like '%#search#%'
                or workZip like '%#search#%'
                or workphone like '%#search#%'
                or homephone like '%#search#%'
        or email like '%#search#%'
        or homeZip like '%#search#%'
        </cfif>
        Order By Lastname ASC
</cfquery>
thanks for any suggestions!
mark
----------------------------------------------------------
To post, send email to list@dfwcfug.org
To unsubscribe: 
  http://www.dfwcfug.org/form_MemberUnsubscribe.cfm
To subscribe: 
  http://www.dfwcfug.org/form_MemberRegistration.cfm