Re: FindNoCase Function

[Alexander Lamon]

Sherry,

How 'bout converting both sides of the WHERE clause to all upper (or 
lower) case?  Might be simpler way of bypassing case-sensitivity e.g.

SELECT *
 from aTable
  where upper(proj_name) LIKE '%#UCase(projcontains)#%';



>
>SELECT *
>FROM pwcntrct
>
>...various other CFIF statements
>
>
>   WHERE proj_name LIKE '%#FindNoCase(projcontains, projcontains)#%'
>
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: FindNoCase Function

[Adrian Wright]

.
.
.
WHERE LOWER(proj_name) LIKE '%#lowerSearchString#%'

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 10:54 AM
To: [EMAIL PROTECTED]
Subject: FindNoCase Function


I have the following text box on a form:




I can put the word "Fire" in the box and press "Find" using the following:

WHERE proj_name LIKE '%#projcontains#%'

and it finds all the correct projects.  But if I put the word "fire", it
doesn't find anything.  So I would like to do a non-case-sensitive search, I
have the following which is not working:


SELECT *
FROM pwcntrct

...various other CFIF statements


WHERE proj_name LIKE '%#FindNoCase(projcontains, projcontains)#%'


I'm not sure how to go about this since the "FindNoCase" function requires a
search string (projcontains) and a target string.  

Sherry Zeiss
Infrastructure Support Services


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: FindNoCase Function

[Olive, Christopher M Mr USACHPPM]

try upcasing the comparison fields.

IE

WHERE
Ucase(proj_name) LIKE '%#Ucase(projcontains)#'

the first Ucase is whatever uppercase function your database supports.

Chris Olive
DOHRS Website Administrator
[EMAIL PROTECTED]


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 29, 2000 11:54 AM
To: [EMAIL PROTECTED]
Subject: FindNoCase Function


I have the following text box on a form:




I can put the word "Fire" in the box and press "Find" using the following:

WHERE proj_name LIKE '%#projcontains#%'

and it finds all the correct projects.  But if I put the word "fire", it
doesn't find anything.  So I would like to do a non-case-sensitive search, I
have the following which is not working:


SELECT *
FROM pwcntrct

...various other CFIF statements


WHERE proj_name LIKE '%#FindNoCase(projcontains, projcontains)#%'


I'm not sure how to go about this since the "FindNoCase" function requires a
search string (projcontains) and a target string.  

Sherry Zeiss
Infrastructure Support Services


--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

FindNoCase Function

[sherry.zeiss]

I have the following text box on a form:




I can put the word "Fire" in the box and press "Find" using the following:

WHERE proj_name LIKE '%#projcontains#%'

and it finds all the correct projects.  But if I put the word "fire", it
doesn't find anything.  So I would like to do a non-case-sensitive search, I
have the following which is not working:


SELECT *
FROM pwcntrct

...various other CFIF statements


WHERE proj_name LIKE '%#FindNoCase(projcontains, projcontains)#%'


I'm not sure how to go about this since the "FindNoCase" function requires a
search string (projcontains) and a target string.  

Sherry Zeiss
Infrastructure Support Services

--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.