Sql Question what is wrong with with sql statement

L

lothos12345

Well-known member
Joined
May 2, 2002
Messages
294
Location
Texas
@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
 
lothos12345 said:
@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
Click to expand...

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