SQL Select Statement for Upper Lower Case Count

[Andy Hilton]

Martin

It depends on the database in question…..which one are you using ?


Andy Hilton
Totally Brilliant Software Inc
Phone (US) : (863) 409 4870 
Phone (UK) : 0207 193 8582
Web : www.totallybrilliant.com 
Helpdesk : https://totallybrilliantsoftware.supportsystem.com/
Email : andyh at totallybrilliant.com

> On Nov 19, 2024, at 5:29 PM, Martin Obongita via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> 
> Hello everyone,
> I have this statement in postgresql that fetched all records that match the supplied value and returns a count: /* 
> Select (count(1)) from person
> 
> Where first_name=@[pFirstName]
> 
> */
> The challenge is that if the first_name has both upper and lower case entries, then it does not return any value if I supply it with a lowercase value.
> Is there a sql select statement that could run and would ignore the case of the of the column and return a value for both uppercase and lowercase columns?
> Martin.
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com