Selecting by case 3

[jorbroni]

I have two types of transactions, one are "a" type transactions and the others are "A" type transactions. The "a" type transactions are the ones I want to select but I dont know how to select by case.

Can anyone help me?

 

[dan1967]

It sounds like you should to put this in the WHERE clause:

WHERE Transaction = 'a'

Dan.

 

[Pattycake245]

WHERE LOWER(Transaction) = 'a'

Just in case the ignore case property is turned on, otherwise the query will look for 'a' and 'A'.

Tim

 

[SQLBill]

Double check that Tim's suggestion gives you the proper results.

LOWER - converts uppercase character data to lowercase.

So it converts what is in the parenthesis to lowercase. I.E. LOWER(Transaction) means all data in the Transaction column will be returned as LOWER case.

Let's say you have this in Transaction:

A
B
a
b

LOWER(Transaction) will return:
a
b
a
b

Try it:

SELECT LOWER(Transaction)

So, Tim's query should return EVERYTHING with either a lowercase a or an uppercase A.

-SQLBill

 

[MDXer]

Cast to a varbinary

WHERE Cast(Transaction as varbinary) = Cast('a' as varbinary)

select Cast('a' as varbinary), Cast('A' as varbinary)
produces the following result

0x61	0x41

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[Pattycake245]

Good point SQLBill. Just call that a slight brain fart on my part. Yes, my suggestion will probably not help you get the results you want.

Tim