sql trouble

[plisken]

This query returns 1:
SELECT 'abc' LIKE 'ABC'

Is it possible to specify what it should return? I need it to return 2 or 3.

[orangehairedboy]

This query returns 1:
SELECT 'abc' LIKE 'ABC'

Well, that's because that's what you asked for 🙂.

Could you tell us a little more about the structure of the table and the contents that you're trying to retreive?

OHB

[plisken]

This will do the trick:
select case when 'abc' LIKE 'ABC' then 2 end

[[deleted]]

You mean

SELECT CASE WHEN 'abc' = 'ABC'
THEN 1
ELSE 2
END AS outcome;

or something....

What do you want to use this for anyway?