quick question 2

[hokky]

Hi guys,

Just quick question
see the code below (which doesn't work)

SELECT * FROM CURVEDEFINITION
where CURVE LIKE ('AUDUSD%DELTA%' OR 'AUDCAD%DELTA%')

As you see, I want to select ALL CURVE LIKE 'AUDUSD%DELTA%' AND 'AUDCAD%DELTA%'

Can you guys tell me how am I suppose to do this in microsoft sql?

Thanks guys,

 

[PDreyer]

where ( CURVE LIKE 'AUDUSD%DELTA%'
OR CURVE LIKE 'AUDCAD%DELTA%')

 

[bborissov]

SELECT *
       FROM CURVEDEFINITION
where (CURVE LIKE 'AUDUSD%DELTA%' OR
       CURVE LIKE 'AUDCAD%DELTA%')

But I am not sure what you want your query uses OR but you want AND?

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.
Microsoft MVP VFP

 

[harebrain]

>But I am not sure what you want your query uses OR but you want AND?

Typical user confusion, Boris, over AND and OR. It must be OR because the conditions are mutually exclusive: AND would never return anything.