Posted by Driesen via SQLMonster.com on 09/30/05 09:17

Hi guys

I having trouble with this sproc. I get the following error when testing:

Server: Msg 245, Level 16, State 1, Procedure UTL_CompletenessCheckLoan, Line
231
Syntax error converting the varchar value 'danwet w125 ' to a column of data
type int.

I have declared @Sellername as Varchar. Please can someone tell me what I'm
doing wrong? All it needs to do is return the 'Y' value if there are numerics
in the sellername.

declare @sellername varchar(40),
@applicationid INT

select @sellername = sellername from Seller where ApplicationId =
@ApplicationId
If @sellername is not null or @sellername <> ''
begin

if (select isnumeric(Sellername) from seller where ApplicationId =
@ApplicationId) = 1
select 'Y'
ELSE
select 'N'
end


Thanks for any help
Driesen


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

[Back to original message]