Thanks, all. I've been asking for the table structure from the user and have not received it yet. Please stay tuned.

Thanks for the reply Bruce.

After I posted the question I discovered and researched DateFormat and I found this, which explained the suggestion you gave

http://www.karaszi.com/SQLServer/info_datetime.asp

This page that proves the...

Point taken. Thanks

If these columns are all character datatypes you could use:

select *

from table

where Name+address+Mob.No.+Designation is null

Otherwise, assuming Mob.No. is a numeric datatype:

select *

from table

where Name+address+convert(varchar(10), Mob.No.)+Designation is null

Maybe a temporary table or table variable with an identity column would suit your needs.  Insert the whichever with an order by clause in your query, then select the rows using...