| 8.1.5 and wildcards [message #369743] |
Mon, 02 October 2000 18:18  |
Rob
Messages: 70
Registered: January 2000
|
Member |
|
|
I've just completed installing a test version of our software onto oracle 8.1.5. Our software fails on customer lookups due to a difference in the response to wildcard characters.
Searching for a (varchar2(8)) customer_number with a query such as "....where customer_number like '00005685%'" fails on 8.1.5 but not on 8.0.5.
A support tech at the software firm complained of the same problem, but said it ended when he upgraded to 8.1.6.
Did I miss something when installing 8.1.5?
|
|
|
|
| Re: 8.1.5 and wildcards [message #369745 is a reply to message #369743] |
Tue, 03 October 2000 02:11  |
Prem
Messages: 79
Registered: August 1998
|
Member |
|
|
Rob,
I can't test it here on my pc, but how abt converting the left-hand side of your where condition to 0 padded string and then comparing. i.e. try
.... where to_char(customer_number, '00000000') like '00005685%'
Another doubt i have is, is the value you have given in the example above the same as what you are using for testing? If so, the length of the customer_number is varchar2(8) and '00005685' itself is 8 characters. so % doesn't make a difference. Its as good as comparing customer_number = '00005685'. Maybe, this was just a typo. anyway, try the to_char... and lemme know if it worked
hth
Prem :)
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
