views:

86

answers:

0

I am using SQL Server 2005 Express.

While I am executed the query I am getting wrong values

 select City, City2
    from
        sample.dbo.NameAddress 
    where
        FirstName like 'rama%' 
        and LastName like 'suresh%'

Getting same values for the both columns but actually they are different in DB,
When I see entire table it is showing exact values.

What to do? Thanks in advance............

--RamaSuresh