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?

Recommended Answers

try this

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

even better to use LIKE for pattern matching.

Jump to Post

All 2 Replies

try this

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

even better to use LIKE for pattern matching.

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 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.