Hi, Kirk

Vlad already gave a sound advice that you sould take note of. Here are my remarks regarding your post:

1) in the procedure declaration, don't forget to set the size for varchar (in this case, 5 - that's why just the first character is inserted in the table, you're using a varchar(1));

2) You're forgetting the begin...end around multiple statements (as you wrote it, after an if just the immediate statement is executed in response to a positive condition; and your else is hanging around without a matching if);

3) quoting from SQL's manual: "GO is not a Transact-SQL statement, it is a command recognized by the osql and isql utilities and SQL Server Query Analyzer."; you shouldn't put it in stored procedure codes;

4) There are what I believe to be a few typos in your code - is this your exact code?


bye