<my guess>
SSN is a dynamically computed column - you can't use that in your WHERE
clause
ie the bit that says:
WHERE s.SSN = p.ssnum
</my guess>

Cheers
Ken

----- Original Message -----
From: "Melinda Savoy" <msavoy@c...>
To: "sql language" <sql_language@p...>
Sent: Saturday, October 21, 2000 1:16 AM
Subject: [sql_language] REPLACE method question - Please help.


> I am using the following query to connect to a linked server and I keeping
> getting an error:  INVALID COLUMN NAME 'SSN'.  What am I doing wrong?
> Here is the code:
>
> select replace(social_security, '-', '') AS SSN, clientid
> from profile s
> join
> svarldwr01.sagentprototype.dbo.physn p
> on s.SSN = p.ssnum
>
> Thank you.