Member Avatar for Frankey

When i do a select on my db. example.

a row with the column 'animal' has the value of 'Horse'


select * from table where animal = 'horSe'

doens't work?!

How to make it work full all variations with capital or non capital?

  • 3 Contributors
  • 2 Replies
  • 107 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by mwasif
Member Avatar for debasisdas

try this

select * from table where upper(animal) = upper('horSe')

even better to use LIKE for pattern matching.

Edited by debasisdas because: n/a
Member Avatar for mwasif

What is the collation of this column in table definition?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.