Hi,
I try to select a few cities in my variable screen with something like this
==“DORDRECHT”
The annoying thing is that it works fine with excel of sql server but not so much with Oracle…
Any clue?
tantetruus (BOB member since 2008-11-11)
p.s.
Seems to work fine with selecting numbers;
Problem seems to be with Text (like city names in my case)
tantetruus (BOB member since 2008-11-11)
Check for UPPER case versus lower case or trailing blanks…?
Andreas 
(BOB member since 2002-06-20)
wouldnt “UPPER case versus lower case or trailing blanks” also apply when BO looks at an excel file of a sql server da\tabase as a source?
Those seem to work fine with the same query
tantetruus (BOB member since 2008-11-11)
Sure, but I do not know what exactly the data in your various data source looks like, do I? 
So did you check?
Andreas (BOB member since 2002-06-20)
hi,
Part of my query looks like this;
==“Alblasserdam”
Of=“ALBLASSERDAM”
Of=“Ameide”
Of=“AMEIDE”
Of=“Arkel”
Of=“ARKEL”
Of=“Binnenmaas”
Of=“BINNENMAAS”
tantetruus (BOB member since 2008-11-11)
Aah, you are working with a Dutch version
It would be easier to use this code:
=Hoofdletters(<Mld Client Woonplaats>)="ALBLASSERDAM"
Of Hoofdletters(<Mld Client Woonplaats>)="AMEIDE"
...
(Upper function in English)
To avoid the problem of possible spaces at the start or end you can use the VerwSptRechts and VerwSptLinks functions (in English LeftTrim and RightTrim).
HenkK
HenkK 
(BOB member since 2004-03-02)
@Henk
The strange thing is that this query works perfect when applied to an excel source and doenst in this case(Oracle source).
It becomes even stranger because in this same Oracle example i can select postal codes in a similar fashion (works perfect).
I ckecked it in the database itself and both variables are in the same table and both seem to be in a text format 
tantetruus (BOB member since 2008-11-11)
Did you try with the Upper function? I think Oracle is very case sensitive, for instance SQL Server isn’t.
To detect if spaces are the problem I sometimes change the formule of a cell to:
=">" & <Mld Client Woonplaats> & "<"Then it’s a lot easier to spot the spaces … or use the Trim functions to get rid of them …
HenkK
HenkK (BOB member since 2004-03-02)
if it doesnt work i first check with a single selection, so,
==“Alblasserdam”
In this case it also does not response to the single approach.
There seems to be something on the background that i miss
tantetruus (BOB member since 2008-11-11)