In attempting to create a new fact table, I have attempted to use the following logic:
CASE WHEN RTRIM(ItemMaster.USCATVLS_4) = 'DROP' THEN TRUE ELSE FALSE END AS [Dropship]
Unfortunately, I am running into an error with Data Type Mismatch. How can I convert that field to be of type variant instead of text? RTRIM(ItemMaster.USCATVLS_4) is of type text to start.
I am aware of the workaround using 'TRUE' and 'FALSE' as strings, but that feels like a hack at best.
Please sign in to leave a comment.