Stored Proc Question

[Driesen P via SQLMonster.com]

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...neral/200508/1

[David Portas]

IF sectionaltitleunitno LIKE '%[^0-9 ]%'
...

--
David Portas
SQL Server MVP
--

[Driesen P via SQLMonster.com]

Thanks very much, David
--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...neral/200508/1