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
----------------------------------
António Tavares Lopes