For maximum flexibility I have users that have asked for ability to be able to just have a textbox and be able to filter themselves. This seems easy but for some reason it will not compile. I made a varchar with length of 255 and of course it does not like having the variable after the 'where' statement. There has to be some way of tricking it into compiling, because the logic will work.
CREATE PROCEDURE mydatabase.text
SELECT LAST, FIRST FROM TABLE
This is totally fake but does resemble the real command. I totally understand why it complains about it but there has to be a way of fooling it.