Case Sensitivity in Searches

Case Sensitivity in Searches

How can I ignore case when trying to SELECT allrecords that are LIKE a certain string variable? I have an employee’s name field in which the charactersare a combination of lower and upper case letters.I do not want users to be concerned about case when doing searches.

The easiest solution is to write your queries using the UPPER() function (or whatever exact syntax your product supports):

    … WHERE UPPER(column)=’NAME’;

Share the Post:
data observability

Data Observability Explained

Data is the lifeblood of any successful business, as it is the driving force behind critical decision-making, insight generation, and strategic development. However, due to its intricate nature, ensuring the

Heading photo, Metadata.

What is Metadata?

What is metadata? Well, It’s an odd concept to wrap your head around. Metadata is essentially the secondary layer of data that tracks details about the “regular” data. The regular