Posted by Driesen P via SQLMonster.com on 08/05/05 14:53

Hi Gurus

I have a sproc that checks a certain field in our software. It is to prevent
users from entering alphabets. The problem I have now is that this sproc is
looking for a number to be in there. I need to only raise the error when
there is an alphabet in this field and NOT if the field is blank. Can someone
tell me what I'm doing wrong? Here is my sproc:

If (select isnumeric(SectionalTitleUnitNo) from sectionaltitle where
applicationid = @applicationid) = 1
Insert into #errors values (1409, @applicationId, 0, 'Y')
Else
Insert into #errors values (1409, @applicationid, 0, 'N')

--The #errors part is my errors table.

Thanks for any help, guys.


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-general/200508/1

• Next in forum: The process could not log conflict information
• Prev in forum: working with daily results : results per day
• Thread view: Stored Proc Question

[Reply to this message]