Hi All,
I am getting ID AS NULL. But I have seen in the database that there is ID with customer name Reliance-tech.
select ID
from Customer
where customername= 'Reliance-tech';
Thanks in advance
Darma
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Mar 18, 2014, 7:05 AM
Hi,
As per my knowledge, select query return null if and only if data is not present.
here it may be you customer name does not exist in data base. it might be change to spell mistake or other mistake....
try..
select ID from Customer
where customername like 'Reliance%';