SELECT

[rlals]

Is there a easy way to write something like:

SELECT * FROM CLIENT WHERE STATUS='A' OR STATUS='L' OR STATUS='F'

I would like something like STATUS in 'ALF', but it doesn't work

Can someone help me?

Thanks

Ricardo

 

[ethorn10]

depends on the database you're using for the LIKE syntax, but something like

SELECT * FROM CLIENT WHERE STATUS LIKE '%ALF%';

for MySQL database and i'm pretty sure like

SELECT * FROM CLIENT WHERE STATUS LIKE '*ALF*';

for Access database.

 

[vikramonline]

SELECT * FROM CLIENT WHERE STATUS in ('A','L','F',........)

I think this might help.

 

[rlals]

Thanks guys.

Ricardo