Hi,
I have another small issue with my Dynamic Registration Form in that I require the person registering to enter a six character code in a text box.
I have an SP that checks that it is valid. It works great if the user enters something in the text box, either valid or otherwise. The SP works fine in this instance.
However, if the user leaves the text box blank then the actual $(CodeUsed) string is passed to the SP and not a blank value. I can obviously have my SP check
IF @CodeUsed = '$(Code' BEGIN
but this is not ideal. Anyone give me a clue as to what I am doing wrong?
Thanks,
Jim.