SP won't compile w/ "Incorrect syntax near the keyword ORDER" error 1

[dddenney]

I have the following SP I am trying to create...

create Proc procDirectoryFilter

(
@Filter nvarchar(1)
)
AS
(
SELECT *
FROM Users
WHERE SUBSTRING(LOWER(LName), 1, 1)=@Filter
ORDER BY LName
)

Everytime I try to compile it in Query Analyzer, it gives me the following error: "Incorrect syntax near the keyword ORDER". If I run the query by itself, it runs with no errors.

Any ideas?

Thanks in advance.

 

[SQLBill]

Your procedure is incorrect. The parenthesis don't belong in the script.

create Proc procDirectoryFilter
  @Filter nvarchar(1)
AS

 SELECT *
 FROM Users 
 WHERE SUBSTRING(LOWER(LName), 1, 1)=@Filter
 ORDER BY LName

See if that works. Refer to the BOL for CREATE PROCEDURE.

-SQLBill

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine

Posting advice: FAQ481-4875

 

[dddenney]

Thanks SQLBill, that did the trick.