Treat Null as empty string in Sybase
Posted on 2006-06-24
I have vendor application which invokes their own sybase stored procedure that contains following piece of code. The value of BEN_CODE in TABLE_A is " ". On invoking stored proc from Visual Basic screen (vendor apps), the @msg is set to ":52D:". I'm trying to create batch program by onvoking same vendor sybase stored procedure but the @msg is getting set to ":52A:". I'm connecting through ISQL session. Any thoughts how I can get the same result - ":52D:" as invoking from Visual Basic screen?
declare @ben_code char(11)
select @ben_code = BEN_CODE from TABLE_A
if rtrim(@ben_code) <> ""
Any inputs to resolve this issue would of great help !