Hi,
I'm looking for advice porting stored procedures from a MS SQL database to SAPDB.
In T-SQL I used a stored procedure like the example below for a user search form:
SELECT * FROM table
WHERE COALESCE(column1, '') LIKE COALESCE(@variable1, '') + '%'
AND COALESCE(column2,'') LIKE COALESCE(@variable2, '') + '%'
AND COALESCE(column3, '') LIKE COALESCE(@variable3, '') + '%'
...
Can I do this in a DBPROC in SAPDB?
Thanks for your help.
Jason Lundquist
