WHERE statement

Question

For example:
WHERE ‘New York’

Is New York case-sensitive?

Answer 1

yes it is, if you don't want case sensitiveness you can apply this functions:
where LOWER (table.name) = LOWER ('New York')
-----
where UPPER (table.name)=UPPER ('New York')

And if you want to remove white spaces: search for the TRIM-function

Answer 2

It depends on the collation of the database.

In Microsoft SQL Server, it's case insensitive by default with SQL_Latin1_General_CP1_CI_AS.

Answer 3

Maria Rodriguez then your statement is not correct, you said:
WHERE city = 'New York';
where city = 'new york';
Yes it doesn't matter if you write WHERE upper or lower case. But it DOES matter if you write NEW YORK, New York or new york. (unless you use the SQL upper or lower functions of course)

Answer 4

Yes must B case-sensitive

Answer 5

yes

Answer 6

Sql is case insensitive. Also the correct statement would be WHERE city=‘New York’; this will give you the same result as typing where city=‘new york’;

Answer 7

Maria Rodriguez it would not return the same result since you typed first New York with uppercase and then new york without uppercase. That's what you meant with SQL is case sensitive, but it is just a typo i guess

Answer 8

I meant sql is case insensitive. Not a typo

Answer 9

yes it is case sensitive and it depends upon the value in table

Answer 10

tape spase 4 times