Thanks ali ... u r reply

Table structure

create table temp( lastname nvarchar(100),locationname nvarchar(100))

lastname locationname

a loc1

...

loc1 and loc2 are not tables..