Sql Question what is wrong with with sql statement

[lothos12345]

@oldfullname = ISNULL(dbo.PatientProfile.[Last],'') + ', ' + isnull( dbo.PatientProfile.[First],'') AS fullname, --stuff after words

 

The error it is giving me is error near AS statement

[frankxcid]

@oldfullname = ISNULL(dbo.PatientProfile.[Last]' date=''') + ', ' + isnull( dbo.PatientProfile.[First'],'') AS fullname, --stuff after words

 

The error it is giving me is error near AS statement

 

Without seeing the rest of your statement, I can only guess that you may have used this alias somewhere else, don't have the SELECT keyword to the left of the variable name, or the column names are wrong