So I have a SQL Query Tag that returns a Workorder. Later on in the process I use that Work Order number to query something else to give me production information. When the tag is [color=#FF0000]null[/color] and I try to use that value to lookup production information I get errors… But if I manually substitute a ZERO it works. Is it possible within the tag defenition somewhere to assign a default value? OR am I missing something in my SQL code that will do this?
SELECT TOP 1 WorkOrderNumber
ORDER BY StartDate
No matter what the great Google box gives me as possible answers I an unable to accomplish this…