Camillia
asked on
Function equal to ISNUL in AS400
In SQL Server, i can do this:
return isnull(@NameString,'')
Meaning, if @nameString is null, return blank.
I thought I can use NULLIF in AS400 but that's not it.
Should I use IF Else to see if it's null, then return blank...more code ...looking for something cleaner if possible...
return isnull(@NameString,'')
Meaning, if @nameString is null, return blank.
I thought I can use NULLIF in AS400 but that's not it.
Should I use IF Else to see if it's null, then return blank...more code ...looking for something cleaner if possible...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.