I have a database with names and phone numbers. Some of the names dont have numbers. How can I select only the names with numbers from the DB?
select * from phoneNumberTable where phoneNumber is not null
select * from tbl where 'the last name ' is null -- suto code<BR><BR>
not null sorry