how to indicate presence of null value to sybase server, for var char fields, just like isnull for numeric fields. The absence of this cause sybase server to throw error message The data for col is null but no indicator was available.
you should be able to use isnull for char/varchar as well..you can try like this
if isnull(@charvrbl, '') = ''
print "charvrbl is null"
please note it's not a double quote but two single quotes & we're checking for null condition for char variable & if true we compare two single quotes which would resolve to true condition & would display the print statement.
you can also use -
if @charvrbl is null
which would tell whether it's nullable or not. Hope this is helpful and this was what you were looking for.