Unable to retrive records from database

Dear All,

I’m execute a query

SELECT * FROM LOCATION WHERE LOC_ID=‘123’ ANDLOC_NAME=‘’;

How to get result for this query? The value for LOC_NAME may have value or ‘’.

I’m getting no records when i have one record of this type.

Pls give your valuable suggestions.

Thanks

–Shaik