OCLOperators sqlLikeCaseInsensitive
    m ((username removed) (log details removed): Moving to Documentation namespace)
    No edit summary
     
    (4 intermediate revisions by 2 users not shown)
    Line 1: Line 1:
    <message>Write the content here to display this box</message>
    Use this when you want to match on strings - or part of strings - but ignore case.
    Use this when you want to match on strings - or part of strings - but ignore case.


    It works just like [[OCLOperators sqlLike|sqlLike]] but ignores case.
    It works just like [[Documentation:OCLOperators sqlLike|sqlLike]] but ignores case.


    '''''Note!'''''  
    '''''Note!'''''  


    [[OCLOperators sqlLike|sqlLike]] ''<u>might</u>'' ignore case in ps search - this depends on your database server and its settings.  
    [[Documentation:OCLOperators sqlLike|sqlLike]] ''<u>might</u>'' ignore case in ps search - this depends on your database server and its settings.  


    For example, the Turnkey built-in database '''Sql Server Compact''' does '''not''' ignore case. If you want an easier search, use this operator:
    For example, the Turnkey built-in database '''Sql Server Compact''' does '''not''' ignore case. If you want an easier search, use this operator:
      Person.allinstances->select(a|a.Name.sqlLikeCaseInsensitive('%'+vSeekParam+'%'))
      Person.allinstances->select(a|a.Name.sqlLikeCaseInsensitive('%'+vSeekParam+'%'))
    [[File:2018-07-22 11h09 10.png|none|thumb]]
    [[File:2018-07-22 11h09 10.png|none|thumb|393x393px]]
    [[Category:OCLOperators]]
    [[Category:OCLOperators]]
    {{Edited|July|12|2025}}

    Latest revision as of 05:58, 12 February 2025

    This page was created by Hans.karlsen@mdriven.net on 2018-07-22. Last edited by Stephanie@mdriven.net on 2025-02-12.

    Use this when you want to match on strings - or part of strings - but ignore case.

    It works just like sqlLike but ignores case.

    Note!

    sqlLike might ignore case in ps search - this depends on your database server and its settings.

    For example, the Turnkey built-in database Sql Server Compact does not ignore case. If you want an easier search, use this operator: 

    Person.allinstances->select(a|a.Name.sqlLikeCaseInsensitive('%'+vSeekParam+'%'))
    2018-07-22 11h09 10.png
    Retrieved from "https://learn.mdriven.net/index.php?title=Documentation:OCLOperators_sqlLikeCaseInsensitive&oldid=26424"

    © MDRIVEN . All Rights Reserved

    API Docs
    MDriven World | Portal | Blog | YouTube | StackOverflow | Facebook

    © MDRIVEN . All Rights Reserved