have you checked that Hide Server is not checked on server Network utility?

When you start the service, on the SQL Log Files, what Port number is Logged ?

srikanth B :

Not all numbers are representable in finite digits arithmetics you may want to try:

Declare @val Varchar

set @val = '-3.16E-05'

Select cast(cast(@val...

I really don't understand how even the First update is affecting anything in the Table

UPDATE Table1 

 SET @Month = NULL

 WHERE unit_id ...

 @Month is a variable, Not...

What you need is a left Join depending on the Relationships between the tables it should be something like:

Select c.Contact, Isnull(p.PhoneNo, "None") As Phone

from Contacts c Left join Phones p...

Sorry for the delay I had to do some work

The reason for the missmatch you were getting is that AS collations consider accented...

Sorry to keep asking but: what collation are you using ?

Happy to Help

Sure!

Select  PID as ID from TableA where ID =x

union all

select x

what is the datatype of  the "Surname" column ?

I don't really follow what you want. If you have two columns

all you need is:

Select ID, PID from TableA where ID =x -- This give you all PID matching that...

usually I have found that an scoring system is the way to approach all those conditions.

It is something that has to be developed with great deal of knowledge on your...