Infrastructure Map Server Forum
Welcome to Autodesk’s Infrastructure Map Server Forums. Share your knowledge, ask questions, and explore popular Infrastructure Map Server topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Filter case sensitive

3 REPLIES 3
Reply
Message 1 of 4
pmarseil
218 Views, 3 Replies

Filter case sensitive

Hi,
I'm trying to create a search tool in the studio on a shapefile and sdf where all the content are uppercase. I was thinking that the operator LIKE was supposed to do the job, but it seems that no!

Is somebody know was is exactly the function to do that. I've tried Upper() but not working.
Thanks
3 REPLIES 3
Message 2 of 4
dswilson
in reply to: pmarseil

Upper should be the correct function.

The expression in the advanced expression builder should look something like:

"PropertyName" LIKE Upper('%$USER_VARIABLE%')

Note I added wildcards to both sides of the expression. There is also a bug such that this doesn't appear to work with Extended characters such as é found in non-english languages.

Regards,
Dave
Message 3 of 4
pmarseil
in reply to: pmarseil

Thanks Dave,
The problem was my upper synthax. Now it' work great.
Can you tell me in wich language are the expression builder?

Thanks again
Message 4 of 4
dswilson
in reply to: pmarseil

I don't think the expression is in any formal language syntax. It's FDO syntax as far as I know.

Dave

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report