KMK
Posts: 2
|
| Posted: 08/27/2004, 6:03 AM |
|
Hi,
Im using the UPPER Function since my SYBASE database in case sensitive. Heres my code:
sWhere = sWhere & "UPPER(a.name) like UPPER('%" & replace(pname, "'", "''") & "%')"
I get the following error:
Function UPPER invoked with wrong number or type of argument(s).
Does anyone perhaps know how to resolve this?
thank you
|
 |
 |
Oper
Posts: 1195
|
| Posted: 08/27/2004, 7:29 AM |
|
UCASE(string)
will be faster if you always saved the info lower case or upercase.
so you dont have to convert it during query process.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
KMK
Posts: 2
|
| Posted: 08/27/2004, 7:41 AM |
|
Hi,
thanks for the reply. Please elaborate
|
|
|
|
|
