Hi,I got an error but can't figure it out.Incorrect syntax near the keyword 'ORDER'
Thanks for help. DECLARE @TEMP VARCHAR(50)SET @TEMP = 'A' IF @TEMP=''BEGIN (SELECT TOP 10 EMP_ID AS EmployeeID, LST_NM + ', ' + FRST_NM AS FullName FROM EMPLOYEE where EMP_ID NOT IN (SELECT TOP 10 EMP_ID FROM EMPLOYEE) ORDER BY EMP_ID)ENDELSEBEGIN(SELECT TOP 10 EMP_ID AS EmployeeID, LST_NM + ', ' + FRST_NM AS FullName FROM EMPLOYEE WHERE (UPPER(EMP_ID) LIKE UPPER(@TEMP)) OR ((LST_NM + ', ' + FRST_NM) LIKE UPPER(@TEMP+'%')) AND EMP_ID NOT IN (SELECT TOP 10 EMP_ID FROM EMPLOYEE WHERE (EMP_ID LIKE @TEMP+'%') OR ((LST_NM + ', ' + FRST_NM) LIKE UPPER(@TEMP+'%'))) ORDER BY EMP_ID)END