Hi,

Below is a simple SP created to stimulate my issue.
If I run the SP, it is working correctly.

However, when I debug it in QA, it will print 'Length >0' when I pass '' as input parameters. Why is QA having such a issue which confused me.

Anyone got any ideal why QA is having this issue. I am using SQL2k
with SP4




create procedure dbo.a_123
(
@i_name varchar(50)
)
as begin

if(len(@i_name)>0)
print 'Length > 0'
else
print 'Length = 0'

end
GO